![]() |
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)? |
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 |
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