| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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)? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
This is what I use to show formulas: http://longre.free.fr/english/
Example: =FORMULATEXT(A22;;;;1) Ola Sandstrom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas referencing pivot table cells | Excel Worksheet Functions | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
| how to copy formulas to other cells in excell | Setting up and Configuration of Excel | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Linear Mode
