hiding cells then a button to show them again

  • Thread starter Thread starter aiqtadar
  • Start date Start date
A

aiqtadar

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide Unhide Buttons 3
How do I hide gaps in an Excel 2007 chart? 2
hiding rows 5
macro to hide then show cells 2
Hidden Comments 5
Check Box 1
CF using Toggle Button result 4
Toolbar buttons to hide/unhide sheets 8

Back
Top