Right-click the sheet tab and select Delete
The fastest way to delete a worksheet in Excel is to right-click on the sheet tab at the bottom of your screen and choose Delete Sheet from the menu that appears. The sheet tab is the small labeled area — usually white or gray — that shows the name of each worksheet in your file. If you have multiple sheets, you'll see several tabs lined up horizontally.
When you click Delete Sheet, Excel will ask you to confirm. If the sheet contains data, you'll see a warning that says the sheet will be permanently removed. Click Delete again to confirm, or click Cancel if you change your mind. Once you confirm, that worksheet and all its contents are gone — Excel does not move deleted sheets to a trash folder you can recover from later.
This method works the same way whether you're using Excel on Windows, Mac, or the web version. The sheet tab location is always at the bottom of the spreadsheet window.
Key Takeaways
- Right-click any sheet tab at the bottom of Excel and select Delete Sheet to remove that worksheet from your file.
- Excel will ask you to confirm the deletion, and the sheet is permanently removed once you confirm — there is no undo through a trash folder.
- You can undo a deletion when ready after it happens by pressing Ctrl+Z (Windows) or Command+Z (Mac), but only if you haven't closed the file.
- If you want to keep the data but remove the sheet from view, you can hide the sheet instead of deleting it by right-clicking and selecting Hide.
- You cannot delete a sheet if it is the only worksheet left in your file — Excel requires at least one sheet to exist in every workbook.
Using the Edit menu instead of right-clicking
If right-clicking doesn't work on your device or you prefer using menus, you can delete a sheet through Excel's Edit menu. First, click on the sheet tab you want to delete to select it. Then click the Edit menu at the top of the screen, look for an option called Delete Sheet or Sheet, and select it.
The exact menu path varies slightly depending on which version of Excel you're using. In Excel Online (the web version), the menu structure is slightly different — you may see a dropdown arrow next to the sheet tab instead. Clicking that arrow gives you the same Delete Sheet option. The confirmation step is identical no matter which method you use.
Recovering a deleted sheet if you act quickly
If you delete a sheet by mistake, you have one window of opportunity: when ready press Ctrl+Z on Windows or Command+Z on Mac. This undo command will restore the deleted sheet and all its data, but only if you haven't closed the file yet. Once you close Excel without saving, or once you save the file after deleting the sheet, the undo history is lost.
If you've already closed the file, check your computer's file recovery options. Windows has a Previous Versions feature for files stored on your computer, and cloud services like OneDrive or Google Drive keep version history for a limited time. Right-click the Excel file, select Properties (Windows) or look for version history in your cloud storage, and you may be able to restore an earlier version of the file that still contains the deleted sheet.
Hiding a sheet instead of deleting it
If you want to remove a sheet from view without permanently deleting it, hiding is safer than deletion. Right-click the sheet tab and select Hide. The sheet will disappear from the tab bar, but the data stays in your file. You can unhide it later by right-clicking any visible sheet tab, selecting Unhide, and choosing the sheet you want to restore.
Hiding is useful when you have reference data or calculations you don't want to see every day but might need later. It also protects you from accidentally deleting a sheet you thought you were just removing from view. The hidden sheet takes up almost no space in your file and doesn't affect how the spreadsheet works.
Why Excel won't let you delete your last remaining sheet
Every Excel file must contain at least one worksheet. If you try to delete the only sheet in your workbook, Excel will show an error message saying you cannot delete the last sheet. You'll need to create a new sheet first before you can delete the current one, or you can rename and clear the existing sheet instead of deleting it.
To create a new sheet quickly, right-click any sheet tab and select Insert Sheet, or click the small plus icon that usually appears next to the sheet tabs. Once you have two sheets, you can delete whichever one you don't need.
Deleting multiple sheets at once
If you need to remove several sheets, you can select more than one at a time. Click the first sheet tab you want to delete, then hold Ctrl (Windows) or Command (Mac) and click each additional sheet tab. All selected tabs will highlight. Right-click any of the highlighted tabs and select Delete Sheet. Excel will remove all selected sheets in one action.
Be careful with this method — it's straightforward to accidentally select the wrong sheet when clicking multiple tabs. If you're unsure, delete sheets one at a time instead. The extra few seconds is worth avoiding the mistake of deleting a sheet you meant to keep.
What happens to formulas and links when you delete a sheet
If other sheets in your workbook contain formulas that reference the deleted sheet, those formulas will break. For example, if Sheet2 has a formula that says =Sheet1!A1 (meaning "get the value from cell A1 in Sheet1"), and you delete Sheet1, that formula will show an error like #REF!.
Before deleting a sheet, check whether any other sheets depend on it. You can search for references by using the Find & Replace feature — press Ctrl+H (Windows) or Command+H (Mac), then search for the sheet name followed by an exclamation mark, like SheetName!. If you find references, either update those formulas first or copy the data from the sheet you're about to delete into another location before removing it.
Frequently Asked Questions
Can I undo a sheet deletion after I've closed and reopened the file?
No. Once you close the file, the undo history is cleared. If you've already saved the file after deleting the sheet, the deletion is permanent in that save. Your only option is to check if your cloud storage or computer's backup system has an earlier version of the file you can restore.
What's the difference between deleting and hiding a sheet?
Deleting removes the sheet and its data from the file permanently. Hiding keeps the sheet and its data in the file but removes it from view — you can unhide it anytime. Hiding is safer if you might need the data later.
Why does Excel say I can't delete this sheet?
Excel requires every workbook to have at least one sheet. If you're trying to delete your only sheet, create a new one first. Some sheets may also be protected — if the sheet is locked, you'll need the password to delete it, or ask whoever protected it to unlock it for you.
If I delete a sheet, does it affect the other sheets in my file?
Deleting a sheet doesn't change the data in other sheets, but formulas that reference the deleted sheet will break and show errors. Check for these broken formulas before deleting, or update them to reference a different sheet instead.
How do I delete a sheet in Excel Online?
In Excel Online, click the small arrow or dropdown menu next to the sheet tab name at the bottom. Select Delete from the menu. The process is the same as desktop Excel, and you'll get a confirmation prompt before the sheet is removed.