Right-click the sheet tab and select Delete

To remove a worksheet from your Excel file, right-click on the sheet tab at the bottom of the window — the one with the sheet name on it — and click Delete Sheet from the menu that appears. Excel will ask you to confirm. Click Delete again, and the sheet is gone.

This is the fastest way and works the same in Excel on Windows, Mac, and in Excel online. The sheet tab sits at the very bottom of your spreadsheet, next to any other sheets you have. If you cannot see the tabs, your window may be too small — drag the border between the sheet tabs and the horizontal scroll bar upward to make more room.

Once you delete a sheet, you cannot undo it by pressing Ctrl+Z (or Cmd+Z on Mac) if you have made other changes since the deletion. If you deleted the wrong sheet when ready, undo right away. If you are not sure whether you need the sheet, move it to a separate file first instead of deleting it.

Key Takeaways

  • Right-click the sheet tab at the bottom of the window and select Delete Sheet to remove it permanently.
  • Excel asks you to confirm the deletion — click Delete again to complete it.
  • Undo (Ctrl+Z or Cmd+Z) works only if you delete when ready and have not made other changes since.
  • If you are uncertain about deleting a sheet, cut and paste it into a separate file first as a backup.
  • You cannot delete a sheet if it is the only sheet left in the file — Excel requires at least one sheet per workbook.

Finding the sheet tab if it is not visible

If you do not see the sheet tabs at the bottom of your screen, your window is likely too narrow or the tabs are hidden behind the horizontal scroll bar. Look for the thin border between the sheet tab area and the scroll bar on the left side of the bottom of the window. Click and drag that border to the right to reveal the tabs.

If you have many sheets, the tabs may be scrolled out of view. Use the small arrow buttons to the left of the sheet tabs to scroll through them until you find the one you want to delete. Once the tab is visible, right-click it and select Delete Sheet.

What happens when you delete a sheet

When you delete a worksheet, all the data in it is removed from your file. Any formulas in other sheets that reference cells from the deleted sheet will show an error (usually #REF!). If you have charts or pivot tables that pull data from the deleted sheet, they will also break.

Before you delete a sheet that other parts of your workbook depend on, check whether any other sheets contain formulas that reference it. You can search for the sheet name in your formulas to find these references. If you find them, either update those formulas to point elsewhere or keep the sheet and hide it instead.

Hiding a sheet instead of deleting it

If you want to remove a sheet from view without deleting it permanently, you can hide it. Right-click the sheet tab and select Hide. The sheet will disappear from the tab bar, but all its data remains in the file and any formulas that reference it will still work.

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. Select the one you want to show again and click OK. This approach is safer than deletion if you are not certain you will never need the sheet again.

Deleting multiple sheets at once

To delete more than one sheet in a single action, select them first. Click the tab of the first sheet you want to delete, then hold Ctrl (or Cmd on Mac) and click the tabs of the other sheets. All selected tabs will highlight. Right-click any of the selected tabs and click Delete Sheet. Excel will delete all of them at once.

Be careful with this method — you are removing multiple sheets in one confirmation, so double-check that you have selected only the sheets you actually want gone. If you select the wrong sheet by mistake, click somewhere else to deselect and start over.

Why Excel will not let you delete the last sheet

Excel requires every workbook to have at least one sheet. If you try to delete the only remaining sheet in your file, Excel will show an error message saying you cannot delete it. You must either keep that sheet or create a new one before you can delete the old one.

If you want to start fresh with a blank sheet, create a new sheet first (right-click a tab and select Insert Sheet), then delete the old one. This takes two steps but ensures your file always has at least one sheet to work with.

Frequently Asked Questions

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

No. Once you close the file without saving, the deletion is permanent. If you close the file after deleting a sheet and then reopen it, the sheet will not come back. To recover a deleted sheet, you would need to restore the file from a backup or previous version if your system has one.

What if I deleted a sheet by mistake and already saved the file?

If you have saved the file after the deletion, the sheet is gone. Check whether your computer or cloud storage (OneDrive, Google Drive, etc.) has a file version history or backup. Windows and Mac both keep previous versions of files in some cases, and cloud services often let you restore older versions of a file.

Does deleting a sheet remove it from all copies of the file?

Only from the copy you are working on. If other people have their own copies of the file, their copies still have the sheet. If the file is shared in OneDrive or SharePoint, deleting a sheet affects the shared version that everyone sees.

Can I delete a sheet that is protected or locked?

If a sheet is protected, you may not be able to delete it. You would need to unprotect it first. Right-click the sheet tab, select Unprotect Sheet, and enter the password if one was set. Once unprotected, you can delete it normally.