Excel Workbook Open but Not Visible? Find and Fix It

If an Excel workbook is open but not visible, first select it from View > Switch Windows; if it has been hidden, choose View > Unhide. If neither applies, check whether the Excel window is minimized or positioned off-screen, especially after disconnecting a monitor.

Start by checking which workbook windows are open

Excel can have several workbooks open at once, and the workbook you need may be behind another window rather than missing. In Excel for Microsoft 365 on Windows, select View > Switch Windows and look for the workbook name in the menu. Choose it to bring that workbook forward. If there are multiple workbooks with similar names, check the title bar after switching so you know which file is active.

You can also use the Windows taskbar to find Excel windows. Point to the Excel icon to display its window previews, then select the preview that corresponds to the workbook. If Excel is grouped with other open windows, inspect each preview rather than assuming the first one is the missing file. Alt+Tab cycles through open application windows; keep holding Alt and press Tab until the relevant Excel window is selected.

If you see the workbook name in Switch Windows or a taskbar preview, the file is open. The problem is its window state or position, not necessarily the workbook contents. This distinction helps avoid closing Excel or reopening a file unnecessarily.

Restore a minimized or covered Excel window

A minimized workbook remains open but disappears from the desktop. Select its taskbar preview, or click the Excel icon if it has only one open window. If the Excel window is visible but covered by another application, select its preview or use Alt+Tab to bring it to the front. Double-clicking the window’s title bar maximizes it; clicking the square-shaped Maximize button in the upper-right corner does the same.

When Excel is maximized but the workbook itself is not, look for a smaller workbook window inside Excel. Depending on the window layout, it may be behind another workbook or partly obscured. Use View > Switch Windows to select it. The Windows keyboard shortcut Ctrl+F6 moves to the next workbook window in Excel; Ctrl+Shift+F6 moves to the previous one. These shortcuts switch between workbook windows, not between Excel and unrelated applications.

On a Mac, use the Window menu in Excel to select an open workbook, and use the macOS Dock or Command+Tab to bring Excel forward. Command+Tab switches applications, so it will not by itself choose between two separate workbooks in Excel.

Move a window back from an off-screen monitor

An Excel window can be open beyond the edge of the screen. This often happens after using a second monitor, changing display settings, or connecting a laptop to a dock and later disconnecting it. The workbook may still appear in Switch Windows even though no part of its window is visible.

Select the workbook using View > Switch Windows or its taskbar preview.
Press Windows key+Shift+Left Arrow or Windows key+Shift+Right Arrow to move the active window to another connected display. Repeat if needed.
If the window is still off-screen, press Alt+Space. If the window menu offers Move, choose it, press an arrow key, then move the mouse to bring the window onto the screen. Press Enter to place it.
Once the window is visible, maximize it so it opens in a usable position next time.

The Move method depends on Windows offering that command for the selected window. If the menu or shortcut behaves differently on your computer, reconnect the missing monitor temporarily, if practical, and drag the window back to the main display. Windows display settings can also help you confirm which screens are connected and how they are arranged.

Unhide a workbook window in Excel

Excel can hide a workbook window without closing the workbook. When this has happened, the workbook may remain listed among open workbooks even though its contents cannot be seen. In Excel for Microsoft 365 on Windows, select View > Unhide. If Excel displays a list of hidden workbooks, select the one you want and confirm. The Unhide command is unavailable or inactive when there is no hidden workbook window to restore.

Hiding a workbook window is different from hiding a worksheet. The workbook-level command affects the window containing the file; worksheet hiding affects an individual tab inside a visible workbook. If you have several files open, use the workbook name shown in the Unhide dialog to avoid restoring the wrong one. After unhiding it, save the workbook if you want to preserve changes made to its contents; the window’s visibility alone is not a change to cell data.

On Mac, check Excel’s Window menu for the option to unhide a workbook, if one has been hidden. Menu wording and placement can vary by Excel version. Excel for the web does not use the same desktop workbook-window controls: look for the workbook’s browser tab or reopen it from its location in OneDrive or SharePoint.

Check whether only a worksheet or its tabs are hidden

If the Excel application and workbook window are visible but the sheet you expect is missing, the workbook itself is not invisible. A worksheet may be hidden, or the sheet-tab area may be turned off. In Windows desktop Excel, right-click a visible sheet tab and choose Unhide to see whether the missing worksheet is listed. You can also use Home > Format > Hide & Unhide > Unhide Sheet. Select a sheet and confirm to make its tab visible again.

If no sheet tabs appear at all, check whether the workbook’s sheet-tab display is disabled. Select File > Options > Advanced, then look under Display options for this workbook for Show sheet tabs. The setting applies to the selected workbook, so check that you have the correct file active. If the option is selected but tabs are still not apparent, the horizontal scroll bar or the workbook window’s size may be taking up the available space; maximize the window and inspect the lower edge.

A sheet that is hidden will not appear in the Unhide list if it has been set to a special very-hidden state through Visual Basic for Applications. That is less common and is distinct from ordinary sheet hiding. If this is a work file, ask its owner or administrator before changing VBA settings, since the workbook may use intentional controls or automation.

When Excel opens to a blank or gray screen

A blank Excel window is not always evidence that a workbook is hidden. Excel may have opened without loading the intended file, or the workbook may still be loading. Check View > Switch Windows and the taskbar previews first. If the file is absent, use File > Open > Recent to see whether the intended workbook is listed, or browse to its known folder and open it from there. A recent-file entry is a shortcut to a location, not proof that the file still exists there.

If a workbook is listed but its content area stays blank, allow time for a large file or one with external connections to finish opening. Look for a progress indicator or a message asking whether to enable content, update links, or recover the file. Protected View normally displays the workbook with a warning banner; it does not mean the file has vanished. Only enable editing or content when you trust the file’s source.

If Excel repeatedly shows a blank window when opening any workbook, test whether an add-in or startup customization is involved. Close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the problem disappears there, an add-in or startup item may be contributing. Safe Mode is a diagnostic step, not a repair for a damaged workbook. For persistent problems, update Office and consider the Windows Settings options for repairing Microsoft 365; save work and close Office apps before running a repair.

Distinguish a missing window from a missing file

A workbook that is still open should generally be listed in Excel’s window switcher, or appear as an open Excel window in Windows. A workbook that was closed, moved, renamed, or stored in an unavailable cloud location is a different problem. Look in File > Open > Recent, check the original folder, and verify that OneDrive or SharePoint has finished syncing if the file is stored there. Recent entries can remain after a file has been moved, so use the displayed location or browse to confirm.

If Excel closed unexpectedly, check the Document Recovery pane when Excel starts again. You can also look under File > Info for workbook-management options, although available recovery details depend on the file and how it was saved. AutoRecover and cloud version history can help in some situations, but neither guarantees recovery of every unsaved change. Avoid repeatedly opening, renaming, or overwriting files when you are unsure which copy contains the latest work; make a separate copy before attempting repairs on a valuable or damaged file.

How the fixes differ on Mac and Excel for the web

Excel for Windows has desktop window controls such as View > Switch Windows and View > Unhide. On Mac, use the Excel Window menu to find open workbooks and check its unhide option if a workbook window was hidden. If the window is beyond the edge of the Mac display, reconnecting the previous monitor or adjusting Displays settings may make it accessible. Windows-specific shortcuts such as Alt+Space and Windows key+Shift+Arrow do not apply on Mac.

Excel for the web runs inside a browser, so a workbook may be in another browser tab, browser window, or desktop application rather than hidden as a separate Excel window. Check the browser’s tabs and window previews, and confirm the account and location where the file is stored. If you opened the file in desktop Excel from the browser, switch to the desktop app and use its window controls. Browser refresh can be useful if the page has stopped responding, but first check for unsaved changes or a save indicator before refreshing.

Frequently Asked Questions

Why does Excel say a workbook is open when I cannot see it?
An open workbook can be minimized, behind another window, hidden with Excel’s Unhide command, or positioned on a disconnected monitor. Check View > Switch Windows first, then inspect the taskbar and display setup.

How do I find a hidden workbook in Excel?
In Windows desktop Excel, select View > Unhide and choose the workbook from the list if it appears. If the command is unavailable, the workbook may not be hidden; check Switch Windows and the taskbar instead.

Why can I see the workbook but not its sheet tabs?
The worksheet may be hidden, or the workbook may have sheet tabs turned off. Try right-clicking a visible sheet tab and choosing Unhide, then check File > Options > Advanced for the Show sheet tabs setting.

How do I bring an Excel window back after unplugging a monitor?
Select the window and try Windows key+Shift+Left Arrow or Windows key+Shift+Right Arrow. If needed, use Alt+Space and the Move command, or reconnect the monitor and drag the window back.

Does a blank Excel screen mean my workbook is lost?
No. Check open workbook windows, recent files, and the file’s original folder. A blank screen can mean Excel opened without the intended file, the workbook is still loading, or the file is open in another window.

Can I use these Windows steps in Excel for the web?
Not all of them. Excel for the web uses browser tabs and windows rather than the same desktop workbook-window controls. Check the browser first, then open the workbook in the desktop app if you need its window-management commands.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.