Right-click the sheet tab and select Delete
To delete a worksheet in Excel, right-click on the sheet tab at the bottom of your screen — the one with the sheet name on it — and click Delete from the menu that appears. Excel will ask you to confirm, because deleted sheets cannot be recovered unless you have not saved the file yet.
If you have unsaved changes, you can close the file without saving and the deletion will not stick. Once you save the file, the worksheet is gone for good. There is no undo after you save.
Key Takeaways
- Right-click the sheet tab at the bottom of the window and select Delete to remove a worksheet.
- Excel asks you to confirm the deletion, but only before you save — after you save, the sheet cannot be recovered.
- If the sheet contains data you might need later, move or copy it to another file before deleting.
- You cannot delete a sheet if it is the only sheet left in the workbook — Excel requires at least one sheet.
What happens to data on the deleted sheet
When you delete a worksheet, all the data on that sheet — formulas, values, formatting, charts, everything — is removed. If other sheets in the same workbook contain formulas that reference the deleted sheet, those formulas will show an error like #REF! because they are pointing to data that no longer exists.
Before you delete a sheet that other sheets depend on, check whether any formulas reference it. You can search for sheet references by using Ctrl+H (Find & Replace) and searching for the sheet name followed by an exclamation mark, like Sheet1!. If you find references, either update those formulas first or move the data to a different sheet instead of deleting it.
Moving or copying a sheet instead of deleting
If you want to keep the data but remove it from the current workbook, you can move or copy the sheet to a different file. Right-click the sheet tab and select Move or Copy. A dialog box will open where you can choose to move the sheet to another workbook or copy it to create a duplicate.
Moving transfers the sheet to the new location and removes it from the original file. Copying leaves the original sheet in place and creates an identical copy elsewhere. This approach is safer than deleting if you are not certain you will never need the data again.
Why Excel will not let you delete the last sheet
Excel requires every workbook to have at least one worksheet. If you try to delete the only remaining sheet, Excel will show an error message saying you cannot delete it. To work around this, create a new blank sheet first, then delete the original one.
This requirement exists because a workbook with no sheets cannot function — it has nowhere to store data or formulas. If you want to clear out a sheet rather than delete it, you can select all cells (Ctrl+A) and press Delete to remove the contents while keeping the sheet itself.
Recovering a deleted sheet if you have not saved
If you delete a sheet by mistake and have not saved the file, you can undo the deletion by pressing Ctrl+Z or clicking the undo button in the toolbar. This works only in the current session — once you close the file or save it, the undo history is lost and the sheet cannot be recovered.
If you have already saved the file, there is no built-in recovery option in Excel itself. Some versions of Windows and Mac keep file recovery versions, but this depends on your operating system settings and whether you have file history turned on. Check your system backup or recovery options if you need to restore a file from before the deletion.
Deleting multiple sheets at once
You can select and delete multiple sheets in one action. Hold Ctrl and click each sheet tab you want to delete, then right-click one of the selected tabs and choose Delete. Excel will remove all selected sheets at once after you confirm.
Be careful when selecting multiple sheets — it is straightforward to accidentally include a sheet you meant to keep. Double-check the highlighted tabs before confirming the deletion.
Frequently Asked Questions
Can I undo a sheet deletion after I save the file?
No. Once you save the file, the deleted sheet is permanently gone. Undo (Ctrl+Z) only works before you save. If you deleted a sheet by mistake and already saved, your only option is to restore the file from a backup if you have one.
What if a formula in another sheet references the deleted sheet?
The formula will show a #REF! error because it is trying to pull data from a sheet that no longer exists. You will need to either fix the formula to reference a different sheet or restore the deleted sheet from a backup.
Can I delete a sheet if it has data in it?
Yes, Excel will let you delete a sheet even if it contains data. You will get a confirmation prompt, but if you confirm, the data is deleted along with the sheet. If you might need the data later, move or copy the sheet to another file first.
What is the difference between deleting a sheet and clearing its contents?
Deleting a sheet removes the sheet itself from the workbook. Clearing contents removes only the data inside the sheet while keeping the sheet tab and structure. Use Clear Contents (select all, then Delete) if you want to reuse the sheet but remove what is on it.
Why can't I delete the last sheet in my workbook?
Excel requires at least one sheet in every workbook. If you want to delete your only sheet, create a new blank sheet first, then delete the original. You can rename the new sheet to whatever you need.