hide/unhide cells
 

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

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

thanks Trevor, makes sense!

Alternate method.

Custom Format with ;;; the cells to look blank.

Note: in either method you can still see the value in the Formula bar.

You could hide it there also if you select those cells and
FormatCellsProtectionHidden.

Then protect the worksheet.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 14:15:04 -0800, "garpavco"
wrote:

thanks Trevor, makes sense!