Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Formulas
Is there anyway that I can enter a formula into a cell but in the space where
you originally type in text or anything else that you want, make that blank? Essentially, I just want to hide the actual formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Formulas
Select the cell with your formula
Right-click and select "Format Cells..." Go to the "Protection" Tab Check "Hidden" Click OK Your worksheet will then need to be protected for the "Hidden" property to take effect. HTH Elkar "Troy 2006" wrote: Is there anyway that I can enter a formula into a cell but in the space where you originally type in text or anything else that you want, make that blank? Essentially, I just want to hide the actual formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide formulas that = 0 | Excel Worksheet Functions | |||
how to hide formulas | Excel Discussion (Misc queries) | |||
Hide formulas? | Excel Discussion (Misc queries) | |||
hide formulas | Excel Discussion (Misc queries) | |||
How to hide formulas? | Excel Discussion (Misc queries) |