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 hidden workbooks in Excel one by one
Quickly unhide all hidden workbooks at the same time with Kutools for Excel
Unhide the hidden workbooks in Excel one by one
1. In Excel, click the View tab, then click Unhide in the Window group. See screenshot:
2. If there is only one hidden workbook, after clicking the Unhide command, the hidden workbook will show up. If there are multiple hidden workbooks, you will find them all listing in the Unhide dialog box after clicking the Unhide button in step 1. Select the workbook and click the OK button to display it. See screenshot:
Note: If you want to display all hidden workbooks, you must repeat the above operations.
Quickly unhide all the hidden workbooks in Excel with Kutools for Excel
As Excel does not support you with one option to unhide all the hidden workbooks in bulk, you can try the Unhide All Windows utility of Kutools for Excel. With this utility, you can show all hidden windows at the same time quickly.
Before applying Kutools for Excel, please download and install it firstly.
Click Kutools > Show & Hide > Unhide All Hidden Windows, see screenshot:
Now all hidden workbook windows are displayed.
Note: The number displaying after the function indicates the total number of hidden workbooks in your Excel. If there is no hidden workbook, the function will turns gray and cannot be clicked.
If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.
Quickly unhide all hidden workbooks at the same time with Kutools for Excel
Related articles:
- Hide other sheets
- Unhide all hidden sheets
- Hide other workbooks
- Show hidden ranges (columns and rows)
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!