Hidden content

M

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
 
M

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
 
D

Dave Peterson

Another way is to use a custom number format:

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