How to Unhide Multiple Sheets in Excel

By Matthew Burley

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 1

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

Step 2

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

Step 3

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

Step 4

TypeSub UnhideAllSheets() Dim wsSheet As Worksheet For Each wsSheet In ActiveWorkbook.Worksheets wsSheet.Visible = xlSheetVisible Next wsSheetEnd Subinto the module window, then click the red "X" at the top right corner to close the module window.

Step 5

Return to the Microsoft Excel window.

Step 6

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

Step 7

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

Step 8

Click "UnhideAllSheets," then click "Run."

Tips & Warnings

  • You can unhide your sheets one at a time by right-clicking on a worksheet tab at the bottom of the window and choosing "Unhide," then clicking the sheet you wish to unhide.