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

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