| 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) | |||
Linear Mode
