Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.