Excel Hack

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

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

A dialog box will appear

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

Sheet deletion complete

The sheet has been deleted.

Delete multiple sheets

Select all sheets that you want delete

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

Press Alt + E + L.

Check the precautions

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.

The sheet has been deleted

Multiple sheets have been deleted.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments