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.
Unhide the hidden workbooks in Excel one by one
Unhide all the hidden workbooks in Excel with Kutools for Excel
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...
Unhide the hidden workbooks in Excel one by one
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.
Unhide all the hidden workbooks in Excel with Kutools for Excel
Excel does not support you with one option to unhide all the hidden workbooks, but Kutools for Excel does.
Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 30days. Get it Now.
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.
Related articles:
- Hide other sheets
- Unhide all hidden sheets
- Hide other workbooks
- Show hidden ranges (columns and rows)
Kutools for Excel
More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
