How to Close Microsoft Excel Without Losing Work

How-to basics · Updated November 20, 2026

To close Microsoft Excel safely, save any changes first, then close the workbook or quit Excel using the window controls or the appropriate keyboard shortcut. If Excel asks whether to save, choose Save to keep your edits, Don’t Save to discard them, or Cancel to return to the workbook. The steps below are for Excel for Microsoft 365 on Windows, with notes for Mac and Excel for the web.

What You’ll Need

  • A computer with Excel open and the workbook you want to close.
  • Permission to save the workbook in its current location, if you want to keep changes.
  • If the workbook is stored online, an internet connection may be needed for changes to finish syncing to OneDrive or SharePoint.

You do not need to close a workbook before shutting down your computer, but saving and closing it deliberately helps avoid losing edits or leaving an unsaved-changes prompt unresolved. If you are unsure whether you have changed anything, save before closing.

Step-by-Step

  1. Check which workbook is open. Look at the title bar at the top of the Excel window. If several workbooks are open, make sure the active window is the one you intend to close. Closing a workbook is not the same as quitting Excel: you can close one file and keep working in another, or quit the application and close all its open workbooks.
  2. Save changes you want to keep. On Windows, press Ctrl+S, or select File > Save. If this is the first time you are saving the workbook, Excel may ask you to choose a folder and file name; select a location, enter a name, and select Save. Wait for the save to finish, especially if the file is on a network location or cloud storage. On Mac, press Command+S or choose File > Save.
  3. Choose whether to close just the workbook or all of Excel. To close the current workbook but leave Excel available, use the workbook’s Close button or press Ctrl+W on Windows. To quit Excel itself, select File > Exit, or press Alt+F4 while the Excel window is active. If you have more than one workbook open, quitting Excel can prompt you to save changes in each one. Review each prompt rather than assuming all files were saved.
  4. Use the window’s Close button if that is easier. In Windows, select the X in the upper-right corner of the Excel window. If the workbook is the last open Excel window, this usually closes Excel as well; if other Excel windows remain, they may stay open. Excel’s interface and open-window arrangement can affect what remains on screen, so check whether the app is still open before starting it again. On Mac, the red close button at the upper-left closes the current workbook window, but it normally does not quit the Excel application.
  5. Respond to the save prompt carefully. If a dialog asks whether to save changes, choose Save to preserve them, Don’t Save to discard them, or Cancel if you clicked close by mistake. On Windows, the dialog wording can vary, but the choices have the same general purpose. Do not choose Don’t Save just to clear the prompt unless you are certain you no longer need the edits. If Excel asks you to save under a new name or in a different format, read the message and select the appropriate option before proceeding.
  6. Confirm that the workbook or app has closed. If you closed one workbook, check that its window or document is no longer open; another workbook may still be visible. If you chose File > Exit or quit Excel, the Excel windows should disappear. On Mac, Excel may remain running even when no workbook windows are visible; use Excel > Quit Excel or Command+Q to quit the application. For Excel for the web, close the browser tab when you are done, after allowing any saving or syncing indicator to finish.

In Excel for the web, there is no desktop application to quit in the same way. Your edits are generally saved automatically to OneDrive or SharePoint, but wait for the page to indicate that saving is complete before closing the tab, navigating away, or shutting down the device. A browser tab’s X closes that tab, not the whole browser. If a confirmation appears because the page has unsaved changes, read it before choosing to leave.

Common Mistakes

Confusing Close with Exit. Closing the current workbook ends your work in that file; it does not necessarily quit Excel. Conversely, choosing File > Exit closes Excel and may affect every workbook open in the application. If you want to leave one workbook open while continuing with another, use the workbook’s Close command rather than quitting Excel.

Clicking Don’t Save by habit. The save prompt is a decision, not a routine confirmation. Don’t Save discards edits made since the last saved version, including changes such as cell entries, formatting, and some workbook structure updates. If you are not sure what changed, choose Cancel, inspect the workbook, and save if you want to keep the work.

Assuming AutoSave means every change is safely stored. AutoSave is available for supported files saved to OneDrive or SharePoint, and its availability can depend on the account, file type, and settings. It is not a substitute for checking that syncing has completed. A workbook saved only to your computer may not have AutoSave switched on. Use Ctrl+S on Windows or Command+S on Mac when you want to make a deliberate save.

Closing a browser window when only a workbook tab needs closing. In Excel for the web, closing the tab ends that browser page, while closing the browser may end several tabs. Make sure you are on the correct page and that online edits have finished saving. If you need to return later, you can reopen the workbook from OneDrive or SharePoint.

Force-closing Excel too quickly. Ending the application through Task Manager or force-quitting it on Mac can discard unsaved changes and may interrupt a save. Try the normal close command and allow time for a prompt or save operation first. Use force quit only when Excel is genuinely unresponsive and normal options are unavailable.

Tips

Use the shortcut that matches what you want to accomplish. Ctrl+W in Excel for Windows closes the active workbook window; Alt+F4 closes the active application window and is commonly used to exit Excel. On Mac, Command+W closes the current window, while Command+Q quits Excel. The exact result of closing a window can depend on whether other workbooks are open, so check the screen afterward.

Before closing a workbook with important work, save and then glance at the title bar or the application’s saving status. If you use OneDrive or SharePoint, allow the cloud status to finish updating. This is especially useful after pasting a large data range, refreshing a query, or working with a slow connection. If the save appears stuck, do not repeatedly close and reopen the file; first check whether Excel is still processing.

If you want to close several workbooks but keep Excel available, close each workbook individually and answer any save prompts. If you want to quit the application, use File > Exit on Windows or Excel > Quit Excel on Mac. Saving each workbook first can make the exit process clearer because fewer prompts will appear.

When a prompt lists a file name, read it before choosing an option. This matters when multiple workbooks are open: the prompt may refer to a different workbook from the one you were just editing. If you accidentally start closing the wrong file, choose Cancel, return to the workbook, and confirm which document is active.

For a shared workbook, consider whether other people may be editing it before you close it. Closing your own session does not necessarily remove the file or prevent others from using it, but unfinished changes may not be visible to collaborators until they have saved and synced. If you see a conflict or sync warning, resolve it before assuming your latest edits are available to everyone.

Troubleshooting

Excel asks whether to save, but you are not sure what changed. Select Cancel to return to the workbook. Look for a change you recognize, check the relevant sheets, and save if you want to keep the current version. If you decide the edits are not needed, close again and choose Don’t Save. When in doubt, save a separate copy using File > Save As so you can preserve the current state without overwriting the original.

The workbook will not close because Excel is busy. A calculation, data refresh, file operation, or add-in may be in progress. Wait briefly and see whether Excel becomes responsive. Avoid repeatedly clicking the Close button, since multiple clicks can make it harder to tell which prompt or action is active. If Excel offers a way to cancel the operation, use it only if you are comfortable stopping that task, then save and close normally.

Excel appears frozen and will not respond to the normal commands. Give it time, particularly if the workbook is large or performing a calculation. If it remains unresponsive, you may need to end the task. On Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task. On Mac, press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. These actions can lose unsaved work; after restarting Excel, check for a Document Recovery pane or recovered files, and save any recovered version promptly. Recovery is not guaranteed.

The app window disappeared, but Excel still seems open. On Mac, this is expected if you closed the last workbook window with the red button: the application can remain active without an open document. Choose Excel > Quit Excel or press Command+Q to exit. On Windows, check the taskbar and any other Excel windows; closing one workbook does not always close every workbook or every Excel window.

A cloud workbook seems not to have saved. Check the workbook’s save or sync status and confirm that you are connected to the internet. If a warning identifies a sync conflict, follow its instructions and compare versions before replacing one. Do not assume that closing and reopening immediately will fix a conflict. If needed, use Save As to make a separate local copy while you investigate, then confirm that the correct version is stored in the intended location.

You closed Excel and now need an unsaved file. Reopen Excel and look for Document Recovery, which may appear after an unexpected shutdown. Open a recovered version if one is offered and save it with a clear name. AutoRecover and recovery availability depend on settings and circumstances, so there may be no recoverable copy. For future work, save regularly and use a cloud location or a separate backup when appropriate.

Frequently Asked Questions

How do I close Excel without closing the workbook? You cannot quit the desktop application while keeping its open workbook running in that same Excel session. Save the workbook, then quit Excel. You can open the workbook again later. If your goal is only to leave one file while using another, close that workbook and keep Excel open.

Does Ctrl+W close Excel? In Excel for Windows, Ctrl+W closes the active workbook window. Whether the Excel application remains visible depends on other open windows and the current interface state. To quit Excel, use File > Exit or Alt+F4. On Mac, Command+W closes a window; Command+Q quits the application.

What is the difference between closing a workbook and quitting Excel? Closing a workbook closes the active file, while quitting Excel ends the desktop application and can close all its open workbooks. Save any changes before either action. If several files are open, quitting may produce separate save prompts for them.

Will Excel save my work automatically when I close it? Do not rely on that assumption. AutoSave can save supported cloud-stored workbooks, but it may be unavailable or disabled, and syncing can take time. Press Ctrl+S on Windows or Command+S on Mac and wait for saving to finish before closing.

How do I close Excel on a Mac? Save with Command+S. Use Command+W or the red window button to close a workbook window, or use Excel > Quit Excel or Command+Q to quit Excel completely. The red button alone usually closes the window without quitting the app.

How do I close Excel for the web? Wait until the workbook shows that edits have saved, then close its browser tab. This closes the page rather than a desktop Excel application. If saving is still in progress or a warning appears, resolve it before leaving.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.