How to Unhide Multiple Sheets in Excel

Default documents created in Microsoft Excel are called workbooks. Each of these workbooks is composed of individual spreadsheets known as worksheets. The different worksheets are labeled and accessible through tabs at the bottom of the Excel window. If a workbook becomes very large, you may end up hiding some of the worksheets. This removes them from view, but they still exist as part of the workbook. You can show them again by unhiding the worksheets, but this can typically only be accomplished one worksheet at a time. Fortunately, you can create a macro to unhide multiple worksheets.

Step

Double-click your Excel file to launch it in Microsoft Excel.

Step

Press "Alt" + "F11" to open the Microsoft Visual Basic editor in another window.

Step

Click "Insert" at the top of the window, then click "Module."

Step

Type

Step

Sub UnhideAllSheets() Dim wsSheet As Worksheet

Step

End Sub

Step

into the module window, then click the red "X" at the top right corner to close the module window.

Step

Return to the Microsoft Excel window.

Step

Click the "View" tab at the top of the window.

Step

Click the "Macros" button, then click "View Macros."

Step

Click "UnhideAllSheets," then click "Run."