Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers

up vote 3 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
add comment

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

Your Answer

 
discard

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.