1
Ctrl + SSave before closing
Pressing Ctrl+S before Ctrl+W lets you skip the save dialog and close immediately.
Tip: The safest pattern: 'save regularly with Ctrl+S, close with Ctrl+W at the end.'
Close WorkbookCtrl+WFile Management
Close an Excel Workbook with Ctrl+W —
Differences from Alt+F4 and Safe Exit Procedures
Ctrl+W closes just the workbook and keeps Excel running. Alt+F4 quits the entire application. In real-world work with multiple files open, knowing this distinction makes your operations significantly safer.
Shortcuts you will master in this article
Ctrl + W / Ctrl + S
The risk of closing all files at once with Alt+F4
Pressing Alt+F4 while multiple workbooks are open closes all of them and quits Excel. Save dialogs do appear, but with multiple files open, it's easy to miss one.
Using Ctrl+W closes files one at a time and prompts you to save if there are unsaved changes. This significantly reduces the risk of accidentally closing a file you didn't intend to.
Steps for Closing a Workbook Safely
Covers the pre-close save check and how to differentiate Ctrl+W from Alt+F4.
2
Ctrl + WClose only the current workbook
Excel stays open and all other workbooks remain unaffected.
Tip: Useful for closing a file you opened temporarily for reference.
3
Unsaved changes trigger a save dialogConfirm whether to save
If there are unsaved changes, a 'Save changes?' dialog appears. Press Enter to save, or Alt+N to discard.
Tip: When you want to close without saving, Alt+N (No) confirms the choice.
4
Alt + F4Quit the Excel application entirely
Use Alt+F4 when you're done with all your work. If any files have unsaved changes, a confirmation dialog will appear.
Tip: Keeping the roles of Ctrl+W and Alt+F4 distinct in your mind prevents accidental closures.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Habits for Safe Workbook Closing
Press Ctrl+S before Ctrl+W to prevent forgotten saves.
When multiple workbooks are open, closing one by one with Ctrl+W is safer than quitting with Alt+F4.
If unsure in the save dialog, defaulting to Enter (Save) is the right call.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + W | Close Workbook |
Ctrl + S | Save |
F12 | Save As |
Frequently Asked Questions
Q. Can I recover data after closing with Ctrl+W without saving?
A. Usually not. However, if an AutoRecover file exists, you may be able to restore it from File → Info → Manage Workbook.
Q. Are Ctrl+W and Ctrl+F4 the same?
A. In Excel, both close the current workbook. Ctrl+W is more widely applicable across applications, making it easier to remember.
Q. Is there a way to close multiple workbooks at once?
A. You can press Ctrl+W repeatedly, or use Alt+F4 to quit the application. Either way, watch out for save dialogs on each file.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →