Ctrl + F4 in Excel: Close the Current Workbook

Have you ever finished working on an Excel file and wanted to close it without closing the entire Excel application?

You don’t need to click the Close button every time. Excel has a simple keyboard shortcut called Ctrl + F4 that helps you close the current workbook quickly.

Let’s see how it works.

Keyboard Shortcut to Close the Current Workbook in Excel:

The keyboard shortcut to close the current workbook in Excel is:

Ctrl + F4

How to Close the Current Workbook Using Ctrl + F4?

Follow these steps:

1. Open your Excel workbook.

2. Press Ctrl + F4 on your keyboard.

If you have made changes to the workbook without saving them, Excel displays a message asking whether you want to save your changes.

You can choose:

• Save: Saves your changes and closes the workbook.
• Don’t Save: Closes the workbook without saving the latest changes.
• Cancel: Keeps the workbook open.

If you have already saved the workbook, Excel closes the current workbook immediately without showing the save message.

What happens after closing the workbook?

The Excel application remains open.

You will now see a blank Excel window with the Ribbon but without any worksheet cells.

From here, you can:

• Press Ctrl + N to create a new workbook.
• Press Ctrl + O to open an existing workbook.

Alternative Shortcut: Ctrl + W:

You can also use Ctrl + W to close the current workbook in Excel.

Both Ctrl + W and Ctrl + F4 perform the same action. They close the active workbook without closing the entire Excel application.

What Happens When You Have Multiple Workbooks Open?

If you have multiple Excel workbooks open, pressing Ctrl + F4 closes only the active workbook.

The other open workbooks remain available.

For example, suppose you have three workbooks open:

• Sales Report.xlsx
• Employee Details.xlsx
• Monthly Expenses.xlsx

If Sales Report.xlsx is the active workbook and you press Ctrl + F4, Excel closes Sales Report.xlsx. The other two workbooks remain open.

You can continue using them as usual.

If you want to close all the open Excel workbooks, press Ctrl + F4 repeatedly.

1. Press Ctrl + F4 to close the first active workbook.
2. Press Ctrl + F4 again to close the second workbook.
3. Repeat until all open workbooks are closed.

Even after closing the last workbook, the Excel application remains open. You will see a blank Excel window with the Ribbon but without any worksheet cells.

You can press Ctrl + N to create a new workbook or Ctrl + O to open an existing one.

Difference Between Ctrl + F4 and Alt + F4 in Excel:

Both shortcuts can close windows, but they work differently.

Ctrl + F4	Alt + F4
Closes the current workbook	Closes the active Excel window.
Other open workbooks remain open	You may need to repeat the shortcut to close other open workbook windows.
Used to close the active workbook	Used to close the active window or Excel application when no other workbook window remains.

Important Things to Remember:

• Ctrl + F4 closes only the active workbook, not the entire Excel application.
• If you have unsaved changes, Excel asks whether you want to save them.
• Other open workbooks remain open.
• You can also use Ctrl + W to close the current workbook.
• On some laptops, you may need to press Ctrl + Fn + F4 because the function keys have additional hardware controls.

Frequently Asked Questions:

1. What is the shortcut to close a workbook in Excel?

Press Ctrl + F4 to close the active workbook.

2. Does Ctrl + F4 close Excel completely?

No. It closes only the current workbook. Excel remains open if other workbooks are available.

3. What happens if I have unsaved changes?

Excel displays a save confirmation message. You can choose to save, discard, or cancel the closing action.

4. What is the difference between Ctrl + F4 and Ctrl + W?

Both shortcuts close the active workbook in Excel. You can use either shortcut to close the current workbook.

Final Thoughts:

The Ctrl + F4 shortcut is a quick way to close the current workbook without closing the entire Excel application.

Instead of clicking the Close button, simply press Ctrl + F4 to close the active workbook and continue working in Excel.

For more useful shortcuts, visit our Excel Keyboard Shortcuts page.