Shortcut to delete sheet in Excel

Release Jan 25, 2022Update Aug 24, 2022
Written in Excel for Microsoft 365 version 2202

You can use the access key to quickly delete a sheet. You can organize your file by deleting unnecessary sheets when you have accidentally added too many sheets or copied too many sheets. Please note, however, that deleted sheets cannot be restored. Also, you cannot use the shortcut key to delete a sheet on a Mac.

Delete sheet shortcut

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

Mac
None

Delete one sheet

If you want to delete one sheet, use the following method. However, if there is only one sheet in the file, you cannot delete it, so you need to add a new sheet first, and then delete the existing sheet.

Total Time: 1 minute

Select the sheet you want to delete

Select the sheet you want to delete, and press Alt + E + L.

A dialog box will appear

If there is data in the worksheet, the Microsoft dialog box will appear. Press Enter. If there is no data in the worksheet, the sheet will be deleted immediately.

Sheet deletion complete

The sheet has been deleted.

Delete multiple sheets

While holding down Ctrl, click on all the sheets you want to delete.

Press Alt + E + L.

If there is data in the worksheet, the Microsoft dialog box will appear.

Press Enter.

If there is no data in the worksheet, the sheet will be deleted immediately.