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