Business Tools Blog

Thanks to Kathleen Buchholz and Matt Boggs at Zayo Bandwidth for the idea for this blog.

Hiding multiple worksheets in Microsoft Excel is as easy as selecting multiple sheets, then clicking Format > Sheet > Hide.

Unhiding multiple worksheets is much more tedious … unless you were lucky enough to stumble on Allen Wyatt’s Excel Tips: Unhiding Multiple Worksheets.  Allen points out that a simple macro will unhide all hidden worksheets with one click.

Here’s how:

• Click ALT+F11 to open VBA
• In VBA, click Tools>Macros

• Then paste or type the following code into the Module and click on the X in the upper right corner of the Module to close

Sub UnhideAllSheets()
    Dim wsSheet As Worksheet

    For Each wsSheet In ActiveWorkbook.Worksheets
        wsSheet.Visible = xlSheetVisible
    Next wsSheet
End Sub

• Return to your Excel file and click ALT+F8 to bring up the Macro menu
• Highlight the UnhideAllSheets Macro, and click Run