hide/unhide cells

[Guest]

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

 

[Trevor Shuttleworth]

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

 

[Guest]

thanks Trevor, makes sense!

 

[Gord Dibben]

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
Format>Cells>Protection>Hidden.

Then protect the worksheet.


Gord Dibben Excel MVP