ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you show formulas in certain cells only (not the whole she. (https://www.excelbanter.com/excel-worksheet-functions/13465-how-do-you-show-formulas-certain-cells-only-not-whole-she.html)

andy

How do you show formulas in certain cells only (not the whole she.
 
Is there a way to display the formulas in selected cells only (instead of
displaying formulas for the whole sheet)?

Coltsfan


You could always right click on the ones you want to hide, go to
protection and select hidden. If you protect your document, only the
ones you did not select will show up.


--
Coltsfan
------------------------------------------------------------------------
Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982
View this thread: http://www.excelforum.com/showthread...hreadid=345982


Ola

This is what I use to show formulas: http://longre.free.fr/english/
Example: =FORMULATEXT(A22;;;;1)

Ola Sandstrom



All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com