The simplest way to remove a sheet

Right-click the sheet tab at the bottom of your Excel window and select Delete from the menu that appears. Excel will ask you to confirm — click Delete again, and the sheet is gone. That is the entire process for most situations.

The sheet tabs sit along the bottom of your spreadsheet, usually showing names like "Sheet1", "Sheet2", or whatever you renamed them. If you cannot see the tabs, your window may be too small — drag the divider between the sheet tabs and the horizontal scroll bar to the right to make more room.

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 are trying to clear out a sheet rather than remove it entirely, you can select all the cells and delete their contents instead — the sheet itself stays.

Key Takeaways

  • Right-click any sheet tab at the bottom of the window and select Delete to remove that sheet permanently.
  • Excel requires at least one sheet in every workbook, so you cannot delete the last remaining sheet.
  • If you want to keep the sheet but clear its data, select all cells and delete the contents instead of deleting the sheet.
  • Deleted sheets cannot be recovered unless you have not saved the file yet — use Ctrl+Z when ready if you delete by mistake.
  • You can rename a sheet by right-clicking its tab and selecting Rename, which is useful if you want to keep it but change its purpose.

Using the menu if right-click does not work

If right-clicking the sheet tab does not open a menu, or if you prefer using the ribbon at the top, you can delete through the menu instead. First, click the sheet tab you want to remove so it is the active sheet. Then click the Home tab in the ribbon if you are not already there.

Look for a button labeled Delete in the Cells group on the right side of the ribbon. Click the small arrow next to it and select Delete Sheet from the dropdown. This method takes more steps but produces the same result as right-clicking.

What happens when you delete a sheet

When you delete a sheet, Excel removes it completely from your workbook. Any data on that sheet is lost. If you have not saved the file since you deleted it, you can undo the deletion by pressing Ctrl+Z (or Cmd+Z on a Mac) when ready. Once you save the file, the deletion is permanent.

If other sheets in your workbook contain formulas that reference the deleted sheet — for example, a formula like =Sheet2!A1 — those formulas will break and show an error. Before you delete a sheet that other sheets depend on, search for references to it by using Ctrl+H to open Find and Replace, then search for the sheet name followed by an exclamation mark.

Deleting multiple sheets at once

You can select and delete more than one sheet in a single action. Click the first sheet tab you want to remove, then hold Ctrl and click each additional sheet tab. All selected tabs will highlight. Right-click any of the highlighted tabs and select Delete. Excel will remove all selected sheets at once.

Be careful with this method — it is straightforward to select more sheets than you intended. If you are unsure, delete sheets one at a time instead. The extra clicks take only seconds and reduce the risk of removing something you meant to keep.

Recovering a deleted sheet if you saved by mistake

If you deleted a sheet and then saved the file, the sheet is gone for good in most cases. However, if you are using Excel on a computer with automatic file recovery enabled, you may be able to recover an earlier version. Click File, then Info, then look for Manage Versions or Recover Unsaved Documents. This option appears only if Excel has saved a backup.

If you use OneDrive or SharePoint to store your Excel file, you can restore an earlier version of the entire file. Right-click the file in OneDrive or SharePoint and select Version History. Choose a version from before you deleted the sheet, and Excel will restore the file to that point. This restores the entire workbook, not just the deleted sheet, so any changes you made after the deletion will be lost.

Clearing a sheet instead of deleting it

If you want to reuse a sheet but remove all its data, you do not need to delete it. Select all cells by clicking the box in the top-left corner where the row numbers and column letters meet. Then press Delete. This removes all content but leaves the sheet in place with its name and formatting structure intact.

If you want to remove formatting as well as data, right-click the selected cells and choose Clear Contents. If you want to clear everything including formatting, select Clear All instead. This approach is useful when you have a sheet set up the way you want but need to start fresh with new data.

Frequently Asked Questions

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

No. Once you close the file after deleting a sheet, the deletion cannot be undone. The Undo command only works within the current session. If you deleted a sheet by mistake, press Ctrl+Z when ready before closing the file. If you have already closed it, check your file's version history if it is stored on OneDrive or SharePoint.

What if I delete a sheet that other sheets reference?

Formulas that reference the deleted sheet will show a #REF! error. Before deleting a sheet, use Find and Replace to search for its name followed by an exclamation mark to locate all references. You can then update those formulas to reference a different sheet or remove them before deleting.

Is there a way to hide a sheet instead of deleting it?

Yes. Right-click the sheet tab and select Hide. The sheet stays in the workbook but does not appear in the tabs at the bottom. To unhide it later, right-click any sheet tab and select Unhide, then choose the sheet you want to show again. This is useful if you want to keep data but do not need to see it regularly.

Can I delete a sheet in Excel Online?

Yes, the process is the same. Right-click the sheet tab at the bottom and select Delete. Excel Online works the same way as the desktop version for sheet management. If you are using a mobile app, look for a menu icon next to the sheet name or swipe the sheet tab to reveal delete options.