Is there a way to unhide multiple sheets at one time?

  • Thread starter Thread starter Guest
  • Start date Start date
Quickest way I know is hold down ALT, and then press O then H then U and
enter repeatedly

Think that's it!
 
Catherine

A macro to unhide all sheets.

Sub Show_Sheets()
Dim i As Integer
For i = 1 To ActiveWorkbook.Worksheets.Count
ActiveWorkbook.Worksheets(i).Visible = True
Next i
End Sub

Note: to hide multiple sheets, just select sheets by CTRL + Click then
Format>Sheet>Hide.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Unhide Multiple Sheets 2
Unhide multiple worksheets in workbook 2
Unhide multiple sheets 3
Excel needs the option to unhide multiple sheets at the same time 3
Unhiding multiple sheets 2
Unhide multiple sheets all at once 3
How can I unhide several worksheets at a time? 2
Can I unhide multiple sheets at one time? 3

Back
Top