The fastest way to remove a sheet from your workbook

Right-click the sheet tab at the bottom of your Excel window and select Delete from the menu. Excel will ask you to confirm — click Delete again, and the sheet is gone. If the sheet contains data, Excel warns you before removing it, giving you a chance to cancel.

That's the whole process. The sheet disappears from your workbook immediately, and the remaining sheets shift to fill the gap. If you change your mind within seconds, you can press Ctrl+Z (or Cmd+Z on Mac) to undo the deletion.

Key Takeaways

  • Right-click a sheet tab at the bottom of Excel and select Delete to remove it in one step.
  • Excel shows a warning if the sheet has data, so you won't accidentally delete a sheet with information you need.
  • Pressing Ctrl+Z immediately after deletion will restore the sheet if you change your mind.
  • You cannot delete the last remaining sheet in a workbook — Excel requires at least one sheet to exist.
  • Deleting a sheet is permanent once you save the file, so save a backup copy first if you're unsure.

What happens when you delete a sheet

When you delete a sheet, Excel removes it completely from your workbook. Any formulas in other sheets that reference the deleted sheet will show a #REF! error, because those formulas no longer have data to pull from. If you have a formula in Sheet1 that says =Sheet2!A1 and you delete Sheet2, that formula breaks.

The data in the deleted sheet is not recoverable unless you undo the deletion right away or you have a saved backup of the file. Once you close the workbook without saving, or you save after deleting, the sheet is gone for good. This is why it's worth taking a moment to confirm you don't need the sheet before you delete it.

How to delete a sheet using the menu instead

If right-clicking doesn't work on your device or you prefer using menus, you can delete a sheet through the ribbon. First, click the sheet tab you want to remove so it's the active sheet. Then go to the Home tab, click the dropdown arrow next to Delete (in the Cells group), and select Delete Sheet.

This method takes a few more clicks than right-clicking, but it works the same way. Excel will still ask you to confirm before removing the sheet, and you'll still see a warning if the sheet contains data.

Protecting yourself before you delete

Before you delete a sheet, consider whether any other sheets depend on it. If you have formulas that reference the sheet you're about to remove, those formulas will break. You can search for these references by using Find & Replace — press Ctrl+H, search for the sheet name followed by an exclamation mark (for example, Sheet2!), and see what comes up.

If you're not sure whether you'll need the sheet later, you can hide it instead of deleting it. Right-click the sheet tab and select Hide. The sheet stays in your workbook but doesn't show up in the tabs at the bottom. You can unhide it later by right-clicking any visible sheet tab and selecting Unhide. This gives you a safety net if you change your mind.

Why you can't 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 workbook, Excel will refuse and show an error message. You must keep at least one sheet, even if it's empty.

If you want to clear out a sheet but keep it in your workbook, select all the cells (press Ctrl+A) and delete the contents instead. This removes all the data while leaving the sheet itself intact.

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 delete, then hold Ctrl and click the other sheet tabs you want to remove. All selected tabs will highlight. Right-click any of the highlighted tabs and select Delete. Excel will remove all of them at once.

Be careful with this method — it's easy to accidentally select more sheets than you intended. Double-check that all the highlighted tabs are ones you actually want to delete before you confirm.

Frequently Asked Questions

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

No. Once you save the file after deleting a sheet, that sheet is permanently gone. The undo function only works within the current session. If you realize you deleted the wrong sheet after saving, your only option is to restore from a backup copy if you have one.

What if I delete a sheet by accident?

Press Ctrl+Z immediately to undo the deletion. This works as long as you haven't closed the file or performed other actions since the deletion. If you've already saved, you'll need to close the file without saving to keep the undo history, then reopen it.

Will deleting a sheet affect my other sheets?

Only if other sheets contain formulas that reference the deleted sheet. Those formulas will show #REF! errors. The data in your other sheets won't change, but any calculations that depend on the deleted sheet will break.

Can I delete a sheet that's protected?

If the sheet itself is protected (locked), you can still delete it. If the workbook structure is protected, you won't be able to delete, add, or rename sheets until someone unprotects the workbook with the correct password.