You need to close an Excel workbook or the entire application. The process is simple but varies slightly depending on your goal. Excel provides two primary methods: the X button in the window corner and the File menu. This article explains the exact steps for each method and what happens when you use them.
Key Takeaways: Closing Excel Windows and Files
- Red X button (top-right corner): Closes the active workbook window. If it’s the only open workbook, this action also closes Excel.
- File > Close: Closes the active workbook file but keeps the Excel application window open.
- Alt + F4 keyboard shortcut: Closes the active window, which can be a workbook or the main Excel application.
Understanding the Two Close Actions
Excel distinguishes between closing a file and closing the program itself. The X button and the File > Close command can produce different results based on how many workbooks you have open. The main Excel window contains your workbook tabs, ribbon, and formula bar. When you close the last workbook, Excel may show a blank, gray application window or close completely depending on your settings.
Before you close, Excel checks for unsaved changes. If you have made edits without saving, a dialog box will appear. This prompt asks if you want to save, discard changes, or cancel the close action. This safety feature prevents accidental data loss. You can change this behavior in Excel’s AutoRecover settings under File > Options > Save.
Steps to Close Using the X Button or File Menu
Follow these steps to close your workbook or Excel using the interface buttons.
Method 1: Using the Red X Button
- Locate the red X button
Find the red X in the top-right corner of the window. On a Windows PC, it is in the title bar. On a Mac, it is a red circle on the top-left. - Click the X button
Click the button once with your mouse. If you have unsaved changes, a save prompt will appear. Choose Save, Don’t Save, or Cancel. - Understand the result
If multiple workbooks are open in separate windows, only the active window closes. If this is the last or only workbook, the entire Excel application closes.
Method 2: Using the File Menu
- Click the File tab
Click the File tab on the far left of the Excel ribbon. This opens the Backstage view. - Select the Close command
In the left-hand menu, click the Close option. Do not click Exit, as that closes the entire application. - Respond to the save prompt
If your workbook has unsaved changes, the same save dialog appears. Select your preferred action to proceed. - Review the Excel window
After closing the file, Excel remains open, showing a gray workspace. You can start a new workbook or open another file from here.
Common Mistakes and Things to Avoid
Users often confuse the different close commands, which can lead to losing their workspace.
Accidentally Clicking Exit Instead of Close
In the File menu, the Close and Exit commands are listed separately. Clicking Exit will close Excel entirely, even if you have other unsaved workbooks open. Always verify you are clicking Close when you only want to shut one file.
Assuming the X Button Always Closes Excel
If you have two workbooks open in separate windows, clicking the X on one window leaves the other open. Excel only closes completely when you close the last open workbook window. Check your Taskbar or Task Manager to see if Excel is still running.
Losing Unsaved Work by Clicking Don’t Save Too Quickly
The save prompt appears quickly. Rushing and clicking Don’t Save will permanently delete any changes made since your last manual save. Take a moment to confirm your choice.
Close Command vs Exit Command: Key Differences
| Item | File > Close | File > Exit |
|---|---|---|
| Primary Action | Closes the active workbook file | Closes the entire Excel application |
| Excel Window After Action | Remains open (blank gray screen) | Completely closes |
| Effect on Other Open Workbooks | No effect, they stay open | All workbooks are closed |
| Keyboard Shortcut | Ctrl + W or Ctrl + F4 | Alt + F4 (when Excel is active) |
| Best For | Working with multiple files | Finishing your Excel session |
You can now close individual workbooks with File > Close or use the X button to shut a window. Remember that the X button’s behavior changes if it’s the last open file. For a faster workflow, use the Ctrl + W shortcut to close the current workbook. To close Excel completely from the keyboard, press Alt + F4.