Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
thanks Trevor, makes sense!
|
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |