Hidden content

[Marie]

I want the contents of a cell hidden but the cell to remain in view. In
other words when someone looks at the spread sheet they think that cell c5
has no data in it until they click on that cell, in the formula bar they can
see the actual contents of the cell. Is this possible?

Marie

 

[Peo Sjoblom]

Format the cell with white fonts

--


Regards,


Peo Sjoblom

 

[Mathew P Bennett]

Easy at would be to format the font colour as white.
Mathew

 

[Mathew P Bennett]

Response as before - format content of cell as white, that way the cell will
look as if there is nothing in it until one chooses it & sees the value in
the formula bar
M

 

[Dave Peterson]

Another way is to use a custom number format:

Format|Cells|Number tab
;;;
(3 semicolons)