Right-click the sheet tab and select Delete

The fastest way to remove a sheet from your workbook is to right-click on the sheet tab at the bottom of the Excel window and choose Delete Sheet from the menu that appears. Excel will ask you to confirm — click Delete again, and the sheet vanishes along with all the data it contained.

This works the same way in Excel on Windows, Mac, and in Excel Online. The sheet tab is the labeled area at the very bottom of your spreadsheet window where you see names like "Sheet1" or "Sales Data". If you have many sheets, you may need to scroll left or right using the arrow buttons to find the one you want to remove.

Once a sheet is deleted, you cannot undo it by pressing Ctrl+Z (or Cmd+Z on Mac) if you have closed the file. If you delete a sheet by accident and realize it when ready, undo will work. If you have already saved and closed the file, the sheet is gone for good — there is no recovery option.

Key Takeaways

  • Right-click any sheet tab at the bottom of Excel and select Delete Sheet to remove it permanently.
  • Excel asks you to confirm the deletion, but once you confirm and save the file, the sheet cannot be recovered.
  • You can undo a deletion when ready with Ctrl+Z (or Cmd+Z on Mac), but only before you close the file.
  • If you are unsure whether you need a sheet, move it to a separate backup file instead of deleting it.
  • Deleting a sheet does not affect other sheets in the same workbook — only the sheet you selected is removed.

Why you might want to delete a sheet

As a spreadsheet grows, you may accumulate sheets you no longer use. A sheet might contain outdated sales figures, a draft version of a report, or test data you created while building formulas. Keeping unnecessary sheets makes the file larger, harder to navigate, and easier to edit by mistake.

Deleting unused sheets keeps your workbook focused on the data that matters. If your file has 20 sheets but only 3 contain information you actually reference, removing the other 17 makes it faster to find what you need and reduces the chance you will accidentally change the wrong data.

How to delete a sheet safely if you are not sure

If you think you might need the sheet later, do not delete it yet. Instead, create a new workbook called something like "Archive.xlsx" and move the sheet there. Right-click the sheet tab, select Move or Copy, and choose Move to end in a different file. This keeps the data safe without cluttering your active workbook.

You can also rename a sheet to mark it as old or unused without removing it. Right-click the sheet tab and select Rename, then type something like "OLD - 2023 Budget" or "Draft - Do Not Use". This makes it clear the sheet is not part of your current work, and you can delete it later once you are certain you do not need it.

What happens when you delete a sheet

Deleting a sheet removes the entire sheet and every cell, formula, and value it contains. If other sheets in the same workbook have formulas that reference the deleted sheet — for example, a formula that says =Sheet2!A1 — those formulas will break and display an error like #REF!.

Before you delete a sheet that other sheets might reference, search your workbook for any formulas that point to it. In Excel on Windows, use Ctrl+H to open Find and Replace, then search for the sheet name followed by an exclamation mark (for example, "OldSheet!"). If you find matches, update those formulas to point to a different sheet or delete them before removing the sheet itself.

Deleting multiple sheets at once

If you need to remove several sheets, you can select them together and delete them all at once. Hold Ctrl (or Cmd on Mac) and click each sheet tab you want to remove. Once all the sheets you want are highlighted, right-click any of the selected tabs and choose Delete Sheet. Excel will delete all of them in one action.

Be careful when selecting multiple sheets — it is straightforward to accidentally click the wrong tab. Double-check that only the sheets you intend to remove are highlighted before you confirm the deletion.

Recovering a deleted sheet

If you delete a sheet and when ready realize you made a mistake, press Ctrl+Z (or Cmd+Z on Mac) to undo the deletion. This works only if you have not closed the file or performed other actions since the deletion. The sheet will reappear with all its original data intact.

If you have already saved the file after deleting the sheet, undo will not work. Excel does not keep a history of deleted sheets in previous versions of the file unless you have enabled version history in OneDrive or SharePoint. If your file is stored in OneDrive, you can sometimes recover an older version of the entire workbook by right-clicking the file and selecting Version history, but this restores the whole file to an earlier point — it does not recover just the deleted sheet.

Frequently Asked Questions

Can I delete a sheet if it is the only sheet in the workbook?

No. Excel requires every workbook to have at least one sheet. If you try to delete your only sheet, Excel will show an error message saying you must keep at least one sheet. If you want to clear all the data, delete the contents of the cells instead of deleting the sheet itself, or create a new blank sheet before deleting the old one.

What if I delete a sheet by accident and I already closed the file?

If the file is stored in OneDrive or SharePoint, you may be able to restore an earlier version. Right-click the file in OneDrive, select Version history, and choose a version from before the deletion. This restores the entire file to that point in time. If the file is stored only on your computer, there is no built-in recovery option — you would need to use file recovery software, which may or may not work depending on how long ago the file was saved.

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

Deleting a sheet does not change the data in other sheets, unless those sheets contain formulas that reference the deleted sheet. Any formula pointing to the deleted sheet will show a #REF! error. You will need to fix or delete those formulas manually.

Can I 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 as a tab at the bottom. You can unhide it later by right-clicking any visible sheet tab and selecting Unhide. This is useful if you want to keep a sheet but do not want it visible to other people who use the file.