Shortcut to delete sheet in Excel
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.
Multiple sheets have been deleted.