How to close Excel sheet shortcut
If you want to close the sheet in Excel, there are several ways. You can use different shortcut keys depending on how you want to close the sheet, for example, if you want to close only a specific sheet, or if you want to close the entire sheet. Find the shortcut key that best suits your needs and use Excel more efficiently.
Close sheet shortcut
Close only one sheet shortcut
Access Key: Alt + E + L or Alt + H + D + S
Close all sheets shortcut
Ctrl + W or Ctrl + F4
Access Key: Alt + F4
command + W or control + W
Close only one sheet
If you want to close only one sheet, use the following method. Please note, however, that closed sheets cannot be restored.
Total Time: 1 minute
Select a sheet
Select the sheet you want to close. Press Alt + E + L.
A dialog box will appear
The Microsoft Excel dialog box is now displayed. Press Enter.
The sheet closes
The sheet is now closed.
Close all sheet
If you want to close all sheet, use the following method. Please note, however, sheets cannot be restored and if you will use Alt + F4, the Excel application will also close.
Select one of the sheets.
Press Ctrl + W or Alt + F4.
The Microsoft Excel dialog box is now displayed.
Use → (Right Arrow key) to select Save or Don’t Save and press Enter.
However, if you have never saved the file, the Save As dialog box will appear.
All the sheets are now closed.