How to Unhide Multiple Sheets in Excel

Co-authored by wikiHow Staff

Last Updated: January 21, 2021 Tested

This wikiHow teaches you how to unhide hidden worksheets in an Excel spreadsheet, using Mac or Windows. Excel only allows you to unhide one sheet at a time, and does not let you select multiple sheets at once.

6 Step Summary

1. Open an Excel file.
2. Right-click a sheet tab in bottom-left.
3. Select Unhide.
4. Select a sheet.
5. Click OK.
6. Repeat for every other hidden sheet.

Steps

1
Open an Excel spreadsheet file. Every Excel document lists all of its worksheets on a tabs bar in the lower-left corner of the spreadsheet.
2
Right-click a sheet on the tabs bar. Find a list of all the sheets in this file in the lower-left corner of your spreadsheet, and right-click any tab. It will open a pop-up menu.
3
Select Unhide on the menu. This option will open a new pop-up window, and show you a list of all the hidden sheets in this document.
- If this option is grayed out on the pop-up menu, it means this document doesn't contain any hidden worksheets.
4
Select a sheet on the list. Excel's Unhide tool only allows you to unhide one sheet at a time. You can only select one sheet to unhide from the list here.
5
Click OK in the pop-up. This will instantly unhide and reveal the selected sheet in your document. You can see the unhidden sheet on the sheets bar in the lower-left corner of your screen.
6
Unhide the rest of your hidden sheets one by one. Right-click a sheet tab, click Unhide, select a different sheet, and click OK. You will need to repeat these steps for every other sheet you want to unhide.