Hide formulas?

[Guest]

Hello,
Is there a way to hide and unhide entries in a cell? Particularly paste
linked formulas.

Thanks in advance.

Ellen

 

[Guest]

To hide a formula change the on the formatting of the cell, protection tab
tick hidden. you then need to protect the sheet with tools>protection>sheet
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[carl.malmquist]

How about simply formating the cell with three ";" (Format Cells,
Number tab, Custom category, enter ;;

Carl

 

[Guest]

It depends if you want to hide the information in the cell but see it in the
formaula bar then you are correct. If you want to hide it in the formula bar
then it needs to be hidden.

Or you could use both and you would not see either.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)