If an Excel workbook window is hidden in Microsoft 365 for Windows, open Excel and choose View > Unhide, select the workbook, and click OK. If you mean a hidden worksheet rather than the whole workbook, use Home > Format > Hide & Unhide > Unhide Sheet instead; these are different visibility settings.
What a hidden workbook means
Excel can hide the window that displays an open workbook. The workbook is still open in Excel, but its window is not visible alongside the other workbook windows. This is different from hiding a worksheet, closing a workbook, or hiding the workbook file in Windows File Explorer. The distinction matters because each case has a different fix.
For example, a workbook named Sales.xlsx may be open but hidden while another workbook remains visible. The data and worksheets in Sales.xlsx have not automatically been deleted or concealed individually; Excel has simply hidden that workbook’s window. By contrast, hiding the worksheet named January leaves the workbook window visible, but removes that sheet’s tab from the bottom of the Excel window.
Hiding a workbook window is sometimes useful when someone wants to temporarily clear the screen or keep a workbook open without displaying it. It can also happen accidentally. Excel’s Unhide command is the first thing to try when you suspect that a workbook is open but cannot see its window.
Unhide a workbook window in Excel for Windows
In desktop Excel for Microsoft 365 on Windows, use the View tab. The workbook must still be open in the current Excel application instance for it to appear in the Unhide list.
- Switch to the Excel application where you think the workbook is open.
- Select View on the ribbon.
- In the Window group, select Unhide. If the command is unavailable, Excel may not have a hidden workbook window in that instance.
- In the Unhide dialog box, select the workbook name you want to restore.
- Click OK. Excel displays that workbook window again.
If several workbook windows are hidden, the dialog lets you choose which one to show. Check the name carefully, especially if you have multiple files with similar names. Unhiding a window does not change the workbook’s contents, worksheet visibility, or file location; it only makes that workbook window visible.
To hide a workbook window intentionally, select View > Hide. The command applies to the active workbook window, not to an individual sheet. Take care not to confuse Hide with the worksheet commands under Home > Format.
What to do on Mac or Excel for the web
In Excel for Mac, workbook windows are managed through the Window menu. If the workbook is hidden, look for an Unhide command in Window and select the workbook to restore it. The exact arrangement of menu items can vary with the Excel for Mac release, but the desktop concept is the same: unhide the open workbook window, rather than unhide a sheet tab.
Excel for the web does not manage workbook windows in the same way as the Windows and Mac desktop applications, so the desktop View > Unhide workflow may not be available there. If you need to restore a hidden workbook window, open the file in the desktop app and use its Unhide command. A workbook can still contain hidden worksheets when viewed in the browser, and sheet visibility controls may be available through the sheet-tab context menu or the ribbon, depending on the web interface.
On any platform, first confirm which app and file you have open. A workbook in another browser tab, another Excel window, or another desktop-app instance will not necessarily appear in the Unhide dialog for the current instance.
If the workbook is missing from the Unhide list
The Unhide dialog lists hidden workbook windows that are currently open in that Excel instance. It is not a file browser and does not list every workbook saved on your computer. If the expected name is absent, the workbook may be closed, open in a different Excel instance, or not the file you thought was open.
- Check other open Excel windows or browser tabs, and inspect the workbook names shown in the application.
- Use File > Open > Browse in desktop Excel to locate and open the file. If it opens normally, it was not an open hidden window in the instance you checked.
- Search for the file in File Explorer, OneDrive, or the location where it was saved. A hidden workbook window does not make the saved file disappear from its folder.
- If Excel is unresponsive or there are several Excel processes, save work in visible workbooks first. Close and reopen Excel only when you are confident you will not lose unsaved changes.
A workbook can also be open in a separate Excel process—for example, if it was launched from another location or under a different session. That window may not be represented in the current instance’s Unhide list. Find and switch to the other Excel window before deciding the workbook is missing.
Unhide a worksheet instead
If the workbook is visible but one or more sheet tabs are missing, you are probably looking for a hidden worksheet. In Excel for Microsoft 365 on Windows, right-click a visible sheet tab and choose Unhide, or select Home > Format > Hide & Unhide > Unhide Sheet. Select a sheet in the dialog and confirm. Excel restores its tab within the current workbook.
That list only includes worksheets hidden through the ordinary sheet visibility setting. If the Unhide Sheet option is disabled, or the sheet you expect does not appear, check whether the workbook structure is protected or whether the sheet is marked VeryHidden. Workbook structure protection can prevent changes such as hiding or unhiding sheets. The Review tab includes the Protect Workbook control; if protection requires a password, you will need permission and the correct password to change the structure.
There can be more than one hidden worksheet. Repeat the command for each sheet you are authorized to restore. Unhiding a sheet does not automatically reveal hidden rows or columns on that sheet; those are separate display settings. Likewise, unhiding a sheet does not restore a hidden workbook window.
VeryHidden sheets and VBA
Excel also has a less visible worksheet setting called xlSheetVeryHidden. A VeryHidden sheet does not appear in the ordinary Unhide Sheet dialog. This setting is usually applied with Visual Basic for Applications (VBA), rather than the standard ribbon command, and is sometimes used to keep supporting lists or configuration data out of routine view.
If you have legitimate access and need to inspect this setting, open the Visual Basic Editor with Alt+F11 on Windows. In the editor, show Project Explorer with Ctrl+R if it is not visible, select the relevant worksheet under the workbook project, and open the Properties window with F4. The Visible property identifies whether the sheet is visible, hidden, or very hidden. Changing it requires appropriate access to the VBA project; a protected project may prevent inspection or editing.
Do not change a sheet’s visibility just because you can. A hidden sheet may contain formulas, lookup data, or controls that other workbook features rely on. If the file came from an organization or another person, ask its owner or administrator before altering protected settings. VBA changes and macros can have broader effects than a simple display change, so save a separate copy before making changes with code.
Hidden workbook, hidden file, or closed workbook?
These descriptions sound alike but point to different places. A hidden workbook window is an open Excel window that you can restore with View > Unhide in desktop Excel. A hidden worksheet is a tab within a visible workbook and is restored with Unhide Sheet. A hidden file is a file-system setting in Windows; it is managed in File Explorer and is not the same as Excel’s workbook-window command.
A closed workbook is no longer open in that Excel instance, so it will not be listed in the Unhide dialog. Open it from its saved location instead. If you cannot locate it, check recent files, the Recycle Bin, cloud storage, or the folder where it was last saved. These checks help distinguish a visibility issue from a missing or unsaved file.
Also consider whether you are looking at the right workbook. Two files may have similar names, and a workbook may have been renamed or saved to a different folder. Use the title bar or File > Info to check the active workbook’s identity before changing settings.
Prevent accidental hiding and protect your work
If you use Hide to clear the screen, remember that the workbook remains open. Before closing Excel, check whether the workbook needs saving; if you want its window state to persist, save the workbook after making the change. The next time you open it, Excel may restore the saved window state. If you prefer the workbook to be visible on reopening, unhide it and save again.
When working with important files, use these habits:
- Keep a clear naming convention so similarly named workbooks are easy to distinguish.
- Save before closing or restarting Excel, particularly when several workbooks are open.
- When you receive a workbook with missing tabs, ask whether sheets are intentionally hidden or the workbook structure is protected.
- Make a separate copy before changing VBA settings, protection, or unfamiliar workbook properties.
These steps are especially useful with shared workbooks, templates, and files stored in cloud locations. Hiding a window is a display choice, not a security measure: it does not encrypt the workbook or prevent someone with access to the file from opening it. Use appropriate file permissions and protection for sensitive information rather than relying on hidden windows or sheets.
Frequently Asked Questions
How do I know whether the workbook or just a sheet is hidden?
If the entire workbook window is missing but another workbook is visible, try View > Unhide on desktop Excel. If the workbook is open and visible but a tab is missing, use Unhide Sheet. The two commands restore different things.
Why is Excel’s Unhide command greyed out?
For workbook windows, it generally means Excel has no hidden workbook window in the current instance. For worksheets, it can mean there are no ordinarily hidden sheets, or that workbook structure protection is preventing changes. A VeryHidden sheet also will not appear in the normal sheet-unhide dialog.
Can I unhide a workbook that is not open?
No. The Unhide dialog restores a hidden window for a workbook that is already open in that Excel instance. Locate and open a closed workbook using File > Open or its saved location instead.
Does hiding a workbook delete or damage it?
No. Hiding a workbook window changes what is displayed, not the workbook’s data. Still, save important work before closing Excel, and make sure you know which file is active before editing or saving.
Can I unhide a worksheet without the password?
If workbook structure protection requires a password, Excel may prevent you from changing sheet visibility. Ask the workbook owner or administrator for authorized access. A VeryHidden sheet also requires a different method from the ordinary Unhide Sheet command.
Related
- What Is Power Query? Excel Data Cleanup Explained
- AI and Power Query: What It Can and Cannot Do in Excel
- Power Query Split Cell Into Rows: Steps and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Merge Cells in Excel Without Losing Your DataTo merge cells in Excel without losing their contents, first combine the values you need into the top-left…
- Excel Hide Text Under the Next Column?In Excel for Microsoft 365 on Windows, text spills into the next column when that neighboring cell is…
- How to Schedule Send an Email in Outlook on the WebTo schedule an email in Outlook on the web, compose your message, open the arrow beside Send, choose…
- Outlook Webmail Signature: How to Create OneTo create a signature in Outlook webmail, open Settings, find the signature editor, write and format your signature,…
- Yes or No Drop-Down in Excel: How to Set It Up FastTo add a Yes or No drop-down in Excel for Microsoft 365 on Windows, select the cell or…
- Outlook Share Calendar With a Distribution List?Outlook can send a calendar-sharing invitation to a distribution list, but that does not reliably give every member…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.