Cliff

I guess the easy way is to change the font colour to be the same as the
background colour in the cell.

Regards

Trevor


"garpavco" wrote in message
...
can a cell easily be made to hide &/or unhide the info typed in, without
actually adjusting the row width to perform the hide/unhide

for example:
a1 = "vegatables"
a2 = "fruit"
a3 = "fish"
a4 = "dairy"

after hiding, say, a1 & a3, worksheet would look like:
a1 would be blank, yet the word "vegetables" would still be in a1, just
not
visible
a2 = "fruit"
a3 would be blank, yet the word "fish" would still be in a3, just not
visible
a4 = "dairy"

sincerely
--
Cliff