Excel Hack

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

Windows
Access Key: Alt + E + L or Alt + H + D + S

Mac
None

Close all sheets shortcut

Windows
Ctrl + W or Ctrl + F4
Access Key: Alt + F4

Mac
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 a sheet

Select the sheet you want to close. Press Alt + E + L.

A dialog box will appear

Check the precautions

The Microsoft Excel dialog box is now displayed. Press Enter.

The sheet closes

The sheet close

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 a sheet

Select one of the sheets.

Press Ctrl + W or Alt + F4.

Check the precautions

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.

The sheet close

All the sheets are now closed.