Right-click the sheet tab at the bottom and select Delete

To remove a sheet from your Excel workbook, locate the sheet tabs at the bottom of the window. Each tab shows the name of one sheet — usually "Sheet1", "Sheet2", or a custom name you gave it. Right-click directly on the tab of the sheet you want to remove. A menu will appear with several options, including Delete. Click that option, and the sheet is gone.

Excel will ask you to confirm the deletion if the sheet contains data. A dialog box will say something like "Do you want to permanently delete the selected sheets?" Click Delete again to confirm, or click Cancel if you change your mind. Once you confirm, the sheet and all its contents are removed from the workbook permanently — this action cannot be undone with Ctrl+Z.

If you cannot see the sheet tabs at the bottom of your screen, your window may be too small or the tabs may be hidden. Look for a thin gray bar just above the status bar (which shows things like "Ready" or the current cell). The tabs should be there. If the bar is very narrow, you can drag its top edge upward to make more room for the tabs to display.

Key Takeaways

  • Sheet tabs appear at the bottom of the Excel window, and right-clicking any tab opens a menu with the Delete option.
  • Excel asks you to confirm deletion if the sheet has data, and the deletion is permanent — you cannot undo it afterward.
  • You can delete multiple sheets at once by holding Ctrl and clicking each tab, then right-clicking and selecting Delete.
  • Excel will not let you delete a sheet if it is the only sheet left in the workbook — you must have at least one sheet.
  • If you delete a sheet by mistake, close the file without saving to restore it, as long as you have not saved since the deletion.

Deleting multiple sheets at the same time

If you need to remove several sheets, you do not have to delete them one by one. Hold down the Ctrl key (or Cmd on Mac) and click each sheet tab you want to delete. The tabs will highlight in white to show they are selected. Once all the sheets you want to remove are highlighted, right-click any of the selected tabs and choose Delete.

Excel will confirm the deletion once, asking if you want to permanently delete all the selected sheets. Click Delete to remove them all at once. This is faster than deleting sheets individually, especially if your workbook has many sheets you no longer need.

What happens if you delete a sheet by accident

If you delete a sheet and when ready realize the mistake, close the file without saving. Press Ctrl+W (or Cmd+W on Mac) to close the workbook, then click Don't Save when Excel asks if you want to save changes. The file will close with the deleted sheet still in it, because you never saved the deletion.

Open the file again, and the sheet will be back. This only works if you have not saved the file since the deletion. If you have already saved, the sheet is gone for good — Excel does not keep deleted sheets in a trash folder or recovery bin. For this reason, it is a good idea to save your work regularly but also to think twice before deleting a sheet that contains important data.

Why Excel will not let you delete your last sheet

Every Excel workbook must contain at least one sheet. If your workbook has only one sheet and you try to delete it, Excel will show an error message saying something like "You cannot delete the only sheet in the workbook." You must keep at least one sheet, even if it is empty.

If you want to clear out a sheet without deleting it, you can select all the cells and press Delete to remove the contents while keeping the sheet itself. Right-click the sheet tab and choose Rename to give it a name like "Unused" or "Archive" so you remember it is not in active use.

Removing sheets from shared or protected workbooks

If the workbook is shared with other people or protected by a password, you may not be able to delete sheets. A shared workbook is one that multiple people can edit at the same time — Excel tracks changes and prevents certain actions to avoid conflicts. A protected workbook has restrictions set by whoever created it, often to prevent accidental changes to important data.

If you try to delete a sheet and nothing happens, or you see a message saying the action is not allowed, the workbook is likely protected or shared. Ask the person who set up the protection or sharing to remove those restrictions, or ask them to delete the sheet for you. You can also check the Review tab at the top of Excel to see if there is an Unprotect Workbook or Unshare Workbook button available.

Hiding a sheet instead of deleting it

If you are not sure whether you need a sheet, hiding it is safer than deleting it. Right-click the sheet tab and select Hide. The sheet will disappear from view, but it stays in the workbook and all its data remains intact. You can unhide it later by right-clicking any visible sheet tab, selecting Unhide, and choosing the sheet you want to bring back.

Hiding is useful when you have sheets that contain reference data, old versions, or calculations you do not need to see every day but might need later. It keeps your workbook organized without the risk of permanent data loss. If you decide the sheet is truly not needed after hiding it for a while, you can always delete it then.

Frequently Asked Questions

Can I undo a sheet deletion after I save the file?

No. Once you save the file after deleting a sheet, the deletion is permanent. Excel's undo function only works within the current session. Close the file without saving when ready after the deletion if you want to restore the sheet.

What if the sheet tab is not showing at the bottom of my screen?

The sheet tabs may be hidden because the window is too small or scrolled out of view. Look for navigation arrows on the left side of the sheet tab area — these let you scroll through tabs if there are many sheets. You can also drag the divider between the sheet tabs and the horizontal scrollbar to make more room for tabs to display.

Can I delete a sheet that other people are using?

If the workbook is shared, you may not be able to delete sheets, or the deletion may cause problems for others who are editing. Check with the other users or the workbook owner before deleting. In a shared workbook, it is often better to hide the sheet instead.

Does deleting a sheet affect formulas in other sheets?

Yes. If another sheet contains a formula that references the deleted sheet, that formula will show an error like #REF!. Before deleting a sheet, search the workbook for any formulas that reference it, and update those formulas to point to a different sheet or remove the reference.