Right-click the sheet tab and choose Delete, then confirm. From the keyboard, press Alt, H, D, S one key after another, which runs Home → Delete → Delete Sheet on the active sheet.
To delete several sheets in one go, hold Ctrl and click each tab, or click the first tab and Shift-click the last, then use either method above. Every selected sheet is removed.
A deleted sheet cannot be brought back with Ctrl + Z. If you remove the wrong one, close the workbook without saving and reopen it, or restore an earlier version if the file is saved to OneDrive or SharePoint.
Excel asks for confirmation only when the sheet contains data; an empty sheet goes without a prompt. Formulas on other sheets that pointed to the deleted sheet change to #REF!, so check what depends on a sheet before you remove it.
If Delete is greyed out, the workbook structure is protected; turn it off under Review → Protect Workbook. Excel also will not delete the last visible sheet, because every workbook must keep at least one.
In this tutorial, we are going to learn three simple methods to delete sheet in Excel. All these methods are quick and easy to follow. You can use any of these methods which you find convenient to you.
Delete a Sheet using the Keyboard Shortcut
- Alt → H → D → S
- Alt → E → L
You can use a keyboard shortcut to quickly delete a sheet from a workbook.
Delete a Worksheet Using Home Tab
- First, click on the worksheet tab or select the multiple worksheet tabs in case to delete multiple worksheets.
- After that, go to the “Home” tab and click on the “Delete” icon drop-down under the “Cells” group on the ribbon.
- Now, select the “Delete Sheet” option from the drop-down list.
- At this point, you will find your selected worksheet(s) deleted from the current workbook.
Delete a Sheet using Right Click Option
- First, right-click on the worksheet tab and click on the “Delete” option from the list.
- To delete multiple worksheets, select the multiple worksheets and then right-click and click on the “Delete” option
Written by
Puneet Gogia
Microsoft MVP — Excel · Founder, Excel Champs
Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.