How to show or unhide the hidden workbooks in Excel?
Sometimes, you may hide some unwanted workbooks, but if you want to use them, how could you display them as soon as possible? This article explains how to unhide the hidden workbook windows in Excel step by step.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. Read more...
Classic Menu for Office: Bring Classic Menus and Toolbars of Office 2003/XP/2000 Back to Office 2007, 2010 and 2013. Read more...
1. In Excel 2007/2010/2013, click on the View tab and click Unhide in the Window group. See screenshot:
2. If you have hidden one workbook only, after clicking the Unhide command, the hidden workbook will show up. If you have multiple workbooks hidden, you will find them listing in the dialog box. Select the workbook and click OK to unhide it. See screenshot:
Note: If you want to display all of the hidden workbooks, you must repeat the above operations.
Excel does not support you with one option to unhide all the hidden workbooks, but Kutools for Excel does.
After installing Kutools for Excel, apply Unhide All Windows utility as this:
Click Kutools > Show / Hide > Unhide All Windows, see screenshot:
And then all of the hidden workbook windows will be displayed.
Note: The number displaying after the function indicates the number of hidden workbooks in your Excel. If there is no hidden workbook, the function will turns gray and cannot be clicked.
- Hide other sheets
- Unhide all hidden sheets
- Hide other workbooks
- Show hidden ranges (columns and rows)