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