Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a number of sheets that I want to unhide quickly in Excel. Do you know if it is possible to unhide multiple sheets at the same time?

share|improve this question
What version of Excel? – squillman May 13 '10 at 23:29
up vote 4 down vote accepted

If you are able to have macros in your workbook I would go for this option...

You need the first block of code found here. I just tested in Excel 2007 and it works.

share|improve this answer

In 2007, go to the View tab and find the Custom Views button. Unhide all the sheets in your workbook and add a custom view called "ShowAll". Then hide the sheets you want and create another custom view called "HideSome". Now you can quickly hide and show those multiple sheets by selecting a custom view. Of course you'll want to name your custom views better than my example.

In 2003 and earlier, it's under the View menu.

share|improve this answer

Short answer. No. Microsoft doesn't feel that an Unhide All option would make for a less convoluted experience. In fact, just accept the fact that most questions around productivity improvements in Excel are answered with "No".

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .