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

Format the cell with white fonts

--


Regards,


Peo Sjoblom

"Marie" wrote in message
...
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

Easy at would be to format the font colour as white.
Mathew
"Marie" wrote in message
...
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

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
"Marie" wrote in message
...
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

Another way is to use a custom number format:

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



Marie wrote:

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

--

Dave Peterson