Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding cells then a button to show them again
how do i hide a selection of cells and then have a button to bring them
back up again? as in an action button that says "SHOW" and when you click it, the cells you've hidden will show up. many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding cells then a button to show them again
You cannot hide cells alone.
You can hide rows and columns only. Hides the selected rows. CTRL+9 Unhides any hidden rows within the selection. CTRL+SHIFT+( (opening parenthesis) Hides the selected columns. CTRL+0 (zero) Unhides any hidden columns within the selection. CTRL+SHIFT+) (closing parenthesis Gord Dibben MS Excel MVP On 23 Jan 2007 06:58:23 -0800, " wrote: how do i hide a selection of cells and then have a button to bring them back up again? as in an action button that says "SHOW" and when you click it, the cells you've hidden will show up. many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Hiding values in cells | Excel Discussion (Misc queries) | |||
Is it possible to show leading zeros for "number" cells? | Excel Discussion (Misc queries) | |||
Using Command Button to copy cells | Excel Discussion (Misc queries) | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) |