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 spreadsheet and choose Delete from the menu that appears. The sheet tab is the labeled area showing the sheet name — usually "Sheet1", "Sheet2", or whatever you named it. One click removes the entire sheet and all the data in it.

Excel will ask you to confirm before deleting. If the sheet contains data, you'll see a warning message. Click Delete again to confirm, or click Cancel if you change your mind. Once you confirm, the sheet is gone and cannot be undone with the standard undo command, so make sure you actually want to remove it.

Key Takeaways

  • Right-click the sheet tab at the bottom of the window and select Delete to remove a sheet in one action.
  • Excel asks you to confirm deletion, and you cannot undo this action after you confirm, so double-check before proceeding.
  • If you need the data later, move it to another sheet or save a copy of the file before deleting.
  • You can delete multiple sheets at once by holding Ctrl (or Cmd on Mac) and clicking each tab, then right-clicking and selecting Delete.

What happens to your data when you delete a sheet

Deleting a sheet removes all the data in that sheet permanently. The data does not move to another sheet, get archived, or stay in a trash folder — it is gone from the file. If other sheets in your workbook contain formulas that reference the deleted sheet, those formulas will show an error.

Before you delete a sheet, check whether any other sheets depend on it. Look for formulas that start with the sheet name, like =Sheet2!A1. If you find references to the sheet you want to delete, you have two choices: update those formulas to point to a different sheet, or copy the data to another sheet before deleting the original.

How to delete a sheet using the menu instead of right-clicking

If right-clicking does not work on your device or you prefer using the menu, you can delete a sheet through the ribbon. First, click on the sheet tab you want to delete to select it. Then go to the Home tab in the ribbon at the top, find the Cells group, and click the small arrow next to Delete. A dropdown menu will appear with the option Delete Sheet.

This method takes a few more steps than right-clicking, but it works the same way. Excel will still ask you to confirm before removing the sheet, and the deletion is still permanent once you confirm.

Deleting multiple sheets at the same time

If you have several sheets to remove, you can delete them all in one action instead of one at a time. Hold down Ctrl on Windows or Cmd on Mac, then click each sheet tab you want to delete. All the selected tabs will highlight. Right-click any of the highlighted tabs and select Delete.

Excel will ask you to confirm that you want to delete all the selected sheets. Be careful with this method — it is straightforward to select more sheets than you intended, and you cannot undo the deletion after you confirm. If you are unsure, delete one sheet at a time instead.

Keeping a sheet but hiding it instead of deleting

If you want to remove a sheet from view but keep the data, you can hide it instead of deleting it. Right-click the sheet tab and select Hide. The sheet will disappear from the tab bar, but the data stays in your file and formulas can still reference it.

To unhide a sheet later, right-click any visible sheet tab and select Unhide. A dialog box will show all hidden sheets in your workbook. Click the one you want to show and click OK. This approach is useful when you have data you do not need to see regularly but might need to reference or restore.

Protecting your work before deleting sheets

Because deletion cannot be undone after you confirm, consider saving a backup copy of your file before you delete any sheets. Use File > Save As and give the copy a different name, like "Spreadsheet_backup". Keep the backup in a safe location so you can recover the data if you delete something by mistake.

Another option is to move important data to a different sheet before deleting. Select all the data in the sheet you want to delete, copy it, and paste it into another sheet or a new file. Once you have confirmed the data is safe, you can delete the original sheet without worry.

Frequently Asked Questions

Can I undo a sheet deletion?

No. Once you confirm the deletion, the sheet is gone permanently. The standard undo command (Ctrl+Z or Cmd+Z) does not work for sheet deletion. This is why saving a backup before deleting is a good idea if you are unsure.

What if I delete a sheet by accident?

If you have not closed the file, try using undo when ready — sometimes it works if you catch it right away. If undo does not work, close the file without saving and reopen it to restore the deleted sheet. If you have already saved the file, you will need to recover it from a backup or previous version if your system has one.

Will deleting a sheet affect other sheets in my workbook?

Deleting a sheet will not change the data in other sheets, but any formulas that reference the deleted sheet will show an error. Search your workbook for formulas containing the sheet name before you delete to see what will break.

Can I delete the last sheet in a workbook?

No. Excel requires at least one sheet in every workbook. If you try to delete your only sheet, Excel will show an error message and prevent the deletion. You must create a new sheet first, or keep at least one sheet in the file.