Right-click the sheet tab and select Delete

The fastest way to remove a sheet from an Excel file is to right-click on the sheet tab at the bottom of the window and choose Delete Sheet from the menu that appears. Excel will ask you to confirm — click Delete again, and the sheet is gone. This works the same way in Excel on Windows, Mac, and the web version.

If you have only one sheet left in the file, Excel will not let you delete it. You need at least one sheet in every workbook. If you want to start fresh, create a new blank sheet first, then delete the old one.

Key Takeaways

  • Right-click the sheet tab at the bottom of the window and select Delete Sheet to remove it permanently.
  • Excel requires at least one sheet in every file, so you cannot delete your last remaining sheet.
  • Once deleted, a sheet cannot be recovered unless you saved a backup copy or use your file's version history.
  • If you are not sure whether you need a sheet, hide it instead of deleting it — hidden sheets take up almost no space and can be unhidden later.
  • In shared files on OneDrive or SharePoint, other people can see who deleted a sheet and when by checking the file's version history.

What happens when you delete a sheet

Deleting a sheet removes all the data in it permanently. Any formulas in other sheets that reference cells from the deleted sheet will show a #REF! error. If you have a formula in Sheet A that says =Sheet B!A1 and you delete Sheet B, that formula breaks.

The file size shrinks slightly because the data is no longer stored. If the sheet contained thousands of rows or columns, you may notice the file becomes a bit smaller to read or email.

Hide a sheet instead of deleting it

If you are unsure whether you need a sheet, hiding it is safer than deleting it. Right-click the sheet tab, select Hide, and the sheet disappears from view but stays in the file. You can unhide it later by right-clicking any visible sheet tab and choosing Unhide.

Hidden sheets take up almost no space and do not slow down your file. They are useful when you have reference data or old versions of a report that you might need later but do not want cluttering the view every day.

Deleting sheets in shared files

If the file lives on OneDrive, SharePoint, or another cloud service, deleting a sheet is recorded in the file's version history. Other people who have access to the file can see that you deleted it, when you deleted it, and potentially recover it by going back to an earlier version of the file.

To check the version history in Excel on the web, click File, then Version History. In the desktop version, right-click the file in OneDrive or SharePoint and select Version History. You can restore an earlier version if someone deletes a sheet by mistake.

Recovering a deleted sheet

If you deleted a sheet from a file saved on your computer and did not save the file afterward, you can undo the deletion by pressing Ctrl+Z (Windows) or Command+Z (Mac) when ready. This works only if you have not closed the file yet.

Once you close the file, the undo history is lost. If the file is on OneDrive or SharePoint, you can restore an earlier version from the version history. If the file is only on your computer and you have no backup, the sheet cannot be recovered.

Deleting multiple sheets at once

To delete more than one sheet, hold Ctrl (Windows) or Command (Mac) and click each sheet tab you want to remove. They will all highlight. Then right-click one of the highlighted tabs and select Delete Sheet. Excel will delete all of them at once.

Be careful with this method — it is straightforward to accidentally select more sheets than you intended. If you are not sure, delete them one at a time instead.

Moving or copying a sheet instead of deleting

If you want to keep the data but move it elsewhere, you can move or copy a sheet to a different file. Right-click the sheet tab and select Move or Copy. Choose whether to move it (remove it from this file and put it in another) or copy it (keep it here and make a duplicate in another file).

This is useful when you are consolidating multiple files or splitting one large file into smaller ones. You can move sheets between any Excel files that are open at the same time.

Frequently Asked Questions

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

Not through Excel's undo feature. If the file is on OneDrive or SharePoint, you can restore an earlier version. If it is only on your computer with no backup, the sheet is permanently gone.

What if I delete a sheet that other formulas depend on?

Any formula that references the deleted sheet will show #REF! error. You will need to fix those formulas by either restoring the sheet or rewriting the formulas to reference a different sheet.

Does deleting a sheet make the file smaller?

Yes, slightly. The file size shrinks because the data is no longer stored. The reduction is usually small unless the sheet contained a lot of data.

Can I delete a sheet if I do not own the file?

It depends on your permissions. If the file owner gave you edit access, you can delete sheets. If you have read-only or comment-only access, you cannot. Ask the file owner to change your permissions if you need to delete a sheet.

What is the difference between deleting and hiding a sheet?

Deleting removes the sheet and all its data permanently. Hiding keeps the sheet in the file but hides it from view. Hidden sheets can be unhidden later, and they take up almost no space.