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

Thanks in advance.

Ellen

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

Ice Hockey rules (especially the Wightlink Raiders)


"EllenM" wrote:

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

Thanks in advance.

Ellen

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

Carl

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)


"carl.malmquist" wrote:

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

Carl