Right-click the sheet tab and select Delete

The fastest way to delete a sheet in Excel is to right-click on the sheet tab at the bottom of your window and choose Delete from the menu that appears. The sheet tab is the labeled area showing the name of your current sheet — usually it says "Sheet1" or whatever you named it.

When you right-click, Excel will ask you to confirm the deletion. Click Delete again to remove the sheet permanently. If the sheet contains data, Excel will warn you that you are about to permanently delete the contents. There is no undo after this point, so make sure you want to remove it.

If you have only one sheet left in your workbook, Excel will not let you delete it — you must have at least one sheet. If you are trying to delete your last sheet, you will see a message saying the workbook must contain at least one visible sheet.

Key Takeaways

  • Right-click any sheet tab at the bottom of Excel and select Delete to remove that sheet in one step.
  • Excel asks you to confirm deletion and warns if the sheet contains data, but there is no undo after you confirm.
  • You cannot delete the last sheet in a workbook — Excel requires at least one sheet to exist.
  • If you are unsure whether you need the sheet, move or copy it to a different workbook before deleting it.
  • Deleting a sheet removes only that sheet; all other sheets and their data remain unchanged.

Using the Sheet menu instead of right-clicking

If right-clicking does not work on your device or you prefer using the menu bar, you can delete a sheet through Excel's ribbon. First, click on the sheet tab you want to delete to make sure it is selected. Then go to the Sheet menu in the ribbon at the top of the window.

Look for an option labeled Delete Sheet or Delete. Click it, and Excel will show the same confirmation dialog as the right-click method. The result is identical — the sheet is removed from your workbook.

On some versions of Excel, the Sheet menu may be under Home or grouped with other sheet-related options. If you cannot find it immediately, look for any menu item that mentions sheets or sheet management.

Saving a copy of the sheet before you delete it

If you are worried about losing data, you can move or copy the sheet to a different workbook before deleting it from the original. Right-click the sheet tab and select Move or Copy. A dialog box will open asking where you want to move or copy the sheet.

Choose Create a copy if you want to keep both versions. Then select which workbook you want the copy to go into — you can create a new workbook just for backup sheets. Click OK, and Excel will duplicate the sheet in the location you chose.

Once the copy is safely in another workbook, you can return to the original workbook and delete the sheet using the right-click method. This way, you have a backup if you change your mind later or need to reference the data.

What happens to formulas that reference a deleted sheet

If other sheets in your workbook contain formulas that reference the sheet you are about to delete, those formulas will break. For example, if Sheet2 has a formula like =Sheet1!A1 and you delete Sheet1, that formula will show an error.

Before you delete a sheet, search your workbook for any formulas that reference it. You can do this by using Find & Replace (Ctrl+H on Windows, Cmd+H on Mac) and searching for the sheet name followed by an exclamation mark, like SheetName!. This will show you every cell that references that sheet.

If you find references, you have two choices: update those formulas to reference a different sheet, or copy the data from the sheet you want to delete into another sheet before deleting it. Either way, fixing the references first prevents errors in your remaining sheets.

Deleting multiple sheets at once

If you need to remove several sheets, you can select them all at once and delete them together. Right-click on the first sheet tab you want to delete, then hold Ctrl (or Cmd on Mac) and click on each additional sheet tab. All selected tabs will highlight.

Once all the sheets you want to remove are selected, right-click any of the highlighted tabs and choose Delete. Excel will delete all selected sheets in one action. This is faster than deleting them one at a time, but be careful to select only the sheets you actually want to remove.

You still cannot delete all sheets in a workbook — Excel will stop you if you try to select every sheet. At least one sheet must remain.

Recovering a deleted sheet

If you delete a sheet by accident, your first step is to use Ctrl+Z (or Cmd+Z on Mac) immediately to undo the deletion. This works only if you have not made any other changes since the deletion. Undo will restore the sheet exactly as it was.

If you have already saved the file or made other changes, undo will not work. In that case, check whether you saved a backup or previous version of the file. Many computers and cloud services keep older versions of files — you can restore an earlier version and re-open it to recover the deleted sheet.

If no backup exists and undo is no longer available, the sheet cannot be recovered. This is why copying important sheets to a separate workbook before deletion is a good safety step.

Frequently Asked Questions

Can I delete a sheet without seeing a confirmation dialog?

No, Excel always asks you to confirm before deleting a sheet that contains data. This is a safety feature to prevent accidental loss. If the sheet is completely empty, some versions of Excel may delete it without asking, but you will still see a warning if there is any content.

What if the Delete option is grayed out?

The Delete option is grayed out when you are trying to delete the last remaining sheet in your workbook. Excel requires at least one sheet to exist. Create a new sheet first, then you will be able to delete the old one.

Does deleting a sheet affect other sheets in the same workbook?

Deleting a sheet does not change the data in other sheets, but it will break any formulas that reference the deleted sheet. Those formulas will show a #REF! error. Check for references before you delete.

Can I rename a sheet instead of deleting it?

Yes, right-click the sheet tab and select Rename. This is useful if you want to keep the sheet but give it a different name or hide it from view. Renaming is safer than deleting if you are unsure whether you need the sheet later.

How do I hide a sheet instead of deleting it?

Right-click the sheet tab and select Hide. The sheet will disappear from view but the data remains in your workbook. You can unhide it later by right-clicking any sheet tab and selecting Unhide. This is a good middle ground if you want to remove clutter without permanently deleting data.