Right-click the sheet tab and select Delete Sheet
To delete a worksheet in Excel, right-click on the sheet tab at the bottom of your workbook and choose Delete Sheet from the menu that appears. The sheet will be removed immediately. If you accidentally delete a sheet, you can undo the action by pressing Ctrl+Z (or Cmd+Z on Mac) right away — but only if you haven't closed the file.
Excel will not let you delete a sheet if it's the only sheet left in your workbook. You must have at least one sheet remaining. If you see a message saying you can't delete the sheet, create a new blank sheet first, then delete the one you want to remove.
Key Takeaways
- Right-click any sheet tab at the bottom of Excel and select Delete Sheet to remove it permanently from your workbook.
- You cannot delete the last remaining sheet in a workbook — Excel requires at least one sheet to exist.
- Undo (Ctrl+Z or Cmd+Z) works immediately after deletion, but only before you close the file.
- Deleted sheets cannot be recovered after you save and close the file, so double-check the sheet name before confirming deletion.
- If you need to keep the data but remove the sheet, copy the data to another sheet or workbook before deleting.
What happens when you delete a sheet
When you delete a worksheet, all the data in that sheet — formulas, values, formatting, charts, everything — is permanently removed from your workbook. Excel does not move the data to a recycle bin or create a backup copy. The deletion is final once you save the file.
If you realize you deleted the wrong sheet before saving, press Ctrl+Z (or Cmd+Z on Mac) to undo. This works even if you've closed and reopened the file in the same session, as long as you haven't saved. Once you save the workbook, the undo history is cleared and the sheet cannot be recovered.
How to delete multiple sheets at once
To delete more than one sheet in a single action, hold Ctrl (or Cmd on Mac) and click each sheet tab you want to remove. Once all the sheets are selected (they will appear highlighted), right-click any of the selected tabs and choose Delete Sheet. All selected sheets will be deleted together.
Be careful when selecting multiple sheets — it's easy to accidentally click the wrong tab. Review your selection before right-clicking to confirm you're removing the correct sheets.
Deleting a sheet without losing the data
If you want to remove a sheet from your workbook but keep the information it contains, copy the data to another location first. Select all the cells in the sheet (Ctrl+A or Cmd+A), copy them (Ctrl+C or Cmd+C), then paste them into another sheet or a new workbook. Once the data is safely copied, you can delete the original sheet.
Alternatively, you can move the sheet to a different workbook instead of deleting it. Right-click the sheet tab, select Move or Copy, and choose to move it to another open workbook. This keeps the data intact while removing it from your current file.
Why Excel won't let you delete a sheet
Excel requires every workbook to contain at least one worksheet. If you try to delete your only remaining sheet, you'll see an error message saying the action cannot be completed. To work around this, create a new blank sheet first (right-click a sheet tab and select Insert Sheet), then delete the sheet you no longer need.
Some workbooks may also be protected, which can prevent sheet deletion. If you see a message that the sheet is protected, you'll need to unprotect the workbook first. Go to the Review tab and look for an Unprotect Sheet or Unprotect Workbook option.
Hiding a sheet instead of deleting it
If you're unsure about permanently removing a sheet, you can hide it instead. Right-click the sheet tab and select Hide. The sheet will disappear from view but remain in your workbook with all its data intact. You can unhide it later by right-clicking any visible sheet tab and selecting Unhide.
Hiding is useful when you want to keep reference data or old calculations in your workbook but don't need to see them regularly. The hidden sheet takes up minimal space and won't clutter your view, but the data is there if you need it.
Frequently Asked Questions
Can I recover a deleted sheet after I've saved the file?
No. Once you save the workbook after deleting a sheet, the data is permanently gone and cannot be recovered through Excel. If you have a backup or previous version of the file saved elsewhere, you may be able to recover the sheet from that copy.
What's the difference between deleting and hiding a sheet?
Deleting removes the sheet and all its data permanently (after saving). Hiding keeps the sheet and its data in the workbook but hides it from view. You can unhide a hidden sheet anytime, but you cannot recover a deleted sheet after saving.
Why can't I delete the last sheet in my workbook?
Excel requires every workbook to have at least one sheet. If you need to remove your only sheet, create a new blank sheet first, then delete the original one. The new blank sheet will remain as the required minimum.
Can I delete a sheet if the workbook is protected?
Not always. If the workbook or sheet is protected, you may not be able to delete it. Go to the Review tab and look for Unprotect Sheet or Unprotect Workbook to remove the protection first, then try deleting again.
How do I delete a sheet without losing the data inside it?
Copy all the data from the sheet (Ctrl+A, then Ctrl+C), paste it into another sheet or workbook, then delete the original sheet. Alternatively, right-click the sheet tab, select Move or Copy, and move it to a different workbook instead of deleting it.