To close multiple Excel windows without closing a workbook, close each window separately: save any changes, select a window, then click its X or press Ctrl+W on Windows. Repeat for the other windows. If you mean several different workbooks, close each workbook window the same way; Excel does not have a standard one-click command that closes a chosen group while keeping the application open.
First identify what is open. Excel can show several windows for one workbook, or separate windows for different workbooks. Closing a window is not the same as deleting a sheet, and closing one view of a workbook usually leaves its other views open. The steps below apply to Microsoft Excel for Microsoft 365 on Windows.
What You’ll Need
- Excel open with the windows you want to close.
- A moment to save any changes you want to keep. Closing a window can prompt you to save the workbook.
- If you have several windows for the same workbook, the View tab’s Switch Windows list can help you move between them.
Step-by-Step
- Check whether your windows show the same workbook or different workbooks. Look at the workbook names in the title bars. Excel can create more than one window for a single workbook, often with labels such as Budget:1 and Budget:2. Those are separate views of the same file, not two copies of its data. If the titles show different file names, you have multiple workbooks open. This distinction matters because closing one view of a workbook does not necessarily close the other views.
- Save any changes you need to keep. Press Ctrl+S in the active window, or select File > Save. If the workbook has not been saved before, Excel will ask you to choose a name and location. Saving first is useful when you are closing several windows, since you may otherwise have to respond to a save prompt for each workbook. A window showing the same workbook as another may still contain unsaved edits, so do not assume that a duplicate view is automatically safe to close.
- Select the first window to close. Click inside the window, or use View > Switch Windows and choose the workbook window from the list. The active window is the one that will respond to the close command. If several windows have similar names, select one and check its title bar before proceeding. The Switch Windows list is especially helpful when a window is behind another one or minimized.
- Close that window. Click the X in the upper-right corner of the Excel window, or press Ctrl+W. You can also use File > Close to close the active workbook window. If Excel asks whether to save changes, choose Save to keep them, Don’t Save to discard them, or Cancel to leave the window open and review the changes. Read the prompt carefully: choosing Don’t Save can discard edits to the workbook.
- Confirm what remains open. If you closed one of several windows for the same workbook, the other window or windows should remain. If that was the last window showing a workbook, Excel closes that workbook. It may return you to another open workbook, or show Excel’s start screen if no workbook remains open. This is expected and does not by itself mean the workbook was deleted.
- Repeat for each additional window. Choose the next window using View > Switch Windows if necessary, then close it with the X, Ctrl+W, or File > Close. Keep repeating until only the windows you want are left. If Excel displays a save prompt, handle it before moving on; dismissing a prompt or choosing Cancel means that window has not closed.
- Use the taskbar if separate Excel windows are hard to reach. On Windows, point to the Excel icon on the taskbar to see previews of open windows, then select the one you want. You can also select an Excel window with Alt+Tab and close it after confirming its title. Do not click the taskbar icon’s general X or use Alt+F4 unless you intend to exit Excel or close the active window, respectively.
- Exit Excel only if you want to close everything. If your goal is to close every workbook and stop using Excel, save the files and choose File > Exit, or press Alt+F4. Excel may ask about unsaved changes in one or more workbooks. This is different from closing a few windows while leaving Excel running, so use it only when you are ready to quit the application.
For a workbook with multiple views, the process is reversible only in the sense that you can open the workbook again; closing a view does not remove the sheets. If you want to make a separate view before closing one, use View > New Window. Excel gives the additional view a numbered title. Afterward, use View > Switch Windows to choose the view you intend to close. Avoid deleting or renaming the file as a way to remove a window; that affects the file, not just its display.
Common Mistakes
- Confusing a window with a workbook. Two windows may be two views of one file, while two other windows may be separate files. Check the title bar and Switch Windows list before closing anything.
- Using Alt+F4 when you only mean to close one view. On Windows, Alt+F4 closes the active application window and can quit Excel when there is no other window to return to. For a controlled, one-at-a-time approach, use the X or Ctrl+W.
- Assuming clicking X always means no changes are lost. Excel may ask whether to save, and the choice matters. Save if you want the edits. Choose Don’t Save only when you are certain you want to discard them.
- Expecting a single Close All command in the ribbon. Excel for Windows does not provide a general Close All Workbooks button in the standard ribbon. Close each workbook window individually, or exit Excel if you want to close everything and leave the application.
- Closing the wrong workbook in a crowded session. Similar names such as Report, Report final, and Report final 2 are easy to mix up. Confirm the complete title and, if useful, inspect the workbook before closing it.
Tips
- Close extra views first. If your intention is to keep a workbook open, close the numbered duplicate windows before its final remaining window. Check the Switch Windows list afterward to confirm that the workbook still appears.
- Save important work before batch closing. Press Ctrl+S in each workbook you have edited. If you are unsure which files changed, handle each save prompt individually rather than automatically choosing the same option every time.
- Use a predictable sequence. Work through the Switch Windows list one window at a time, close it, then check the list again. This reduces the risk of closing the wrong file when many workbooks have similar names.
- Remember that closing a window is not deleting a workbook. The file remains at its saved location. To open it later, use File > Open, or open it from its folder.
- Distinguish Excel windows from browser tabs. In Excel for the web, each workbook is displayed in a browser tab or browser window. Close the relevant tab using the browser controls, and save or wait for changes to sync first. Excel for the web does not provide the same desktop View > Switch Windows workflow.
Troubleshooting
The window will not close. Look for a dialog box or save prompt covering the workbook. Choose Save, Don’t Save, or Cancel as appropriate. If a cell is being edited, press Enter to accept the entry or Esc to cancel it, then try closing the window again. A modal prompt must usually be answered before Excel accepts other commands.
The workbook disappears after closing a window. You may have closed its last open window. Reopen it with File > Open and locate the saved file. If you had unsaved edits and chose Don’t Save, those edits may not be recoverable, so check AutoRecover or Document Recovery if Excel offers it when you reopen the application. Do not assume recovery is guaranteed.
You cannot tell which window is active. Select View > Switch Windows, choose a listed window, and read its title bar. You can also use Alt+Tab or the taskbar previews to bring a particular Excel window forward. If the list contains numbered entries for one workbook, those entries are separate views of that workbook.
Excel closes completely instead of leaving another window open. Check whether you closed the last open workbook window or used Alt+F4. Start Excel again and open the files you need. To close only selected windows next time, close them one at a time and stop before closing the final window you want to keep.
You are using Excel on a Mac. The same general approach applies, but use the red close control on the window or press Command+W to close the active window; Command+Q quits Excel. Menu labels and window controls can vary slightly by macOS version. Excel for the web is different: close browser tabs rather than using desktop window commands.
Frequently Asked Questions
Can I close multiple Excel windows at once?
Excel for Windows does not offer a standard command to close a selected group of workbook windows while keeping Excel open. Close each one individually. To close everything and quit, save your work and choose File > Exit.
Will closing one window close all views of the same workbook?
No. If the workbook has multiple windows, closing one usually leaves its other views open. Closing the last open window for that workbook closes the workbook itself.
How do I close a duplicate window without deleting the workbook?
Select the duplicate through View > Switch Windows, confirm its title, and click its X or press Ctrl+W. Close only the extra view; do not delete the file from File Explorer.
What is the difference between Ctrl+W and Alt+F4?
Ctrl+W closes the active workbook window. Alt+F4 closes the active application window and may exit Excel if no other Excel window remains. Save changes before using either shortcut.
Does Excel have a Close All button?
Not as a standard command for closing all open workbooks while leaving Excel running. You can close workbooks one by one. File > Exit closes Excel, subject to any save prompts.
How do I close several workbooks in Excel for the web?
Close each workbook’s browser tab or browser window. Check that changes have finished saving or syncing before you close a tab. The desktop Excel Switch Windows command is not the web version’s way to manage workbook tabs.
Related
- Change Table Color in Excel: Styles and Custom Formatting
- Excel Subscript: How to Change Text to Subscript
- How to Change Strikethrough Color in Excel Cells Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Box and Whisker Plot on a Log Scale?Yes—Excel for Microsoft 365 on Windows can display a Box & Whisker chart with a logarithmic vertical value…
- Compare Names in Two Excel Sheets: Find MatchesTo compare names on two Excel sheets, put the names in columns and use a formula such as…
- Copy Excel Formulas to Google Sheets Without ErrorsTo copy a formula from Excel into Google Sheets, copy the formula cell in Excel, select the destination…
- How to Create Address Labels in WordIn Microsoft Word for Microsoft 365 on Windows, go to Mailings > Start Mail Merge > Labels, choose…
- Outlook: Can You Schedule an Email to Be Sent?Yes. Outlook lets you schedule an email to be sent later, although the steps and where the message…
- Power Query Circular Reference: Causes and FixesA Power Query circular reference happens when a query depends on itself, either directly or through other queries,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.