hide formulas

  • Thread starter Thread starter stef
  • Start date Start date
S

stef

Excel 2002 SP3
Win XP HE

Hi,
I have a spreadsheet that has quite a few formulas that I want to
function BUT hide--so that when one clicks on the cells where the
formula is, the formula itself does not show.
How can I achieve that?
 
You can select the whole sheet, do format>protection and deselect locked,
then you select the cells with the formulas (F5, special>formulas enter),
then repeat but select hidden. Then finally you protect the sheet under
tools>protection. That way only the result of the formula is showing and you
can still select and edit other cells


--


Regards,


Peo Sjoblom
 
When you apply protection to a cell through Format | Cells |
Protection tab, you can choose to Lock a cell AND to hide it - ensure
that both are checked (Lock is set by default anyway).

Then using Tools | Protection you can Protect the sheet (or those
cells which have at least one of the settings above checked) - you
will be asked to provide an optional password, as well as having
options on what to protect on the sheet.

Those cells which have a setting of Hidden will only display the
result of a formula, not the formula itself.

Hope this helps.

Pete
 
It does help, thanks!

Pete_UK said:
When you apply protection to a cell through Format | Cells |
Protection tab, you can choose to Lock a cell AND to hide it - ensure
that both are checked (Lock is set by default anyway).

Then using Tools | Protection you can Protect the sheet (or those
cells which have at least one of the settings above checked) - you
will be asked to provide an optional password, as well as having
options on what to protect on the sheet.

Those cells which have a setting of Hidden will only display the
result of a formula, not the formula itself.

Hope this helps.

Pete
Click to expand...
 
Back
Top