Right-click the sheet tab at the bottom and select Delete

In Excel, each sheet appears as a tab at the bottom of your window. To remove a sheet, find the tab with the name you want to delete, right-click it, 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 whether you are using Excel on Windows, Mac, or the web version. The sheet tab is always at the bottom of the screen, and the right-click menu is always your fastest route.

If you cannot see the sheet tabs, your window may be too narrow or the tabs may be hidden. Widen the window by dragging its edge, or look for small arrow buttons on the left side of the tab area — these let you scroll through sheets if there are many of them.

Key Takeaways

  • Right-click any sheet tab at the bottom of Excel and select Delete Sheet to remove it permanently.
  • Excel asks you to confirm the deletion before it happens, so you have a moment to change your mind.
  • Deleting a sheet removes all data in that sheet, but does not affect other sheets in the same file.
  • If you are not sure you want to delete a sheet, save a copy of the file first or move the data to another sheet before deleting.

What happens when you delete a sheet

When you delete a sheet, all the data in that sheet is removed permanently. Excel does not send it to a trash folder or recovery bin — it is gone from the file. The other sheets in your spreadsheet are not affected at all.

If you realize you made a mistake right after deleting, you can undo the action by pressing Ctrl+Z (Windows) or Command+Z (Mac). This works only if you have not closed the file yet. Once you close and reopen the file, the undo history is cleared and you cannot recover the deleted sheet.

Before you delete: make sure you have what you need

Before you right-click and delete, take a moment to check whether the data in that sheet exists anywhere else. Open the sheet and look at what is there. If it contains information you might need later, copy it to another sheet first, or save a separate copy of the entire file as a backup.

A common situation: you have a sheet called "Old Data" or "Archive" that you no longer use. Before deleting it, scroll through to confirm it really is old and that nothing important is mixed in. If the sheet contains formulas that reference other sheets, deleting it might break those formulas in the remaining sheets — so check your other sheets first to see if they depend on it.

Deleting a sheet when Excel asks for confirmation

After you right-click and select Delete Sheet, a dialog box appears asking "Do you want to permanently delete the selected sheet?" This is your chance to stop. Click "Delete" to confirm, or click "Cancel" to keep the sheet.

If you see a message saying the sheet contains data and asking if you are sure, that is Excel warning you that you are about to lose information. Read the warning carefully. If you are certain you want to delete it, click Delete. If you are not sure, click Cancel and review the sheet first.

Hiding a sheet instead of deleting it

If you want a sheet out of the way but are not ready to delete it, you can hide it instead. Right-click the sheet tab and select "Hide" — the sheet disappears from view but the data stays in the file. You can unhide it later by right-clicking any visible sheet tab and selecting "Unhide".

Hiding is useful when you have sheets you use only occasionally, or when you want to clean up the tab area without losing data. The hidden sheet still takes up space in the file, but it does not clutter your workspace.

Deleting multiple sheets at once

If you need to remove several sheets, you can select them all before deleting. 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 — all of them will be removed at once.

Be extra careful when deleting multiple sheets, because the confirmation dialog will not list each sheet individually. You will see only a message asking if you want to delete the selected sheets. Make sure you have the right ones highlighted before you confirm.

If you cannot delete a sheet

Excel will not let you delete a sheet if it is the only sheet left in the file — every spreadsheet must have at least one sheet. If the Delete Sheet option is grayed out or does not appear, check whether you have other sheets. If you do, try right-clicking again. If you do not, create a new sheet first, then delete the one you want to remove.

In some cases, a file may be protected or shared with other people, and the owner may have locked the ability to delete sheets. If you see a message saying the sheet is protected or the file is read-only, you will need to ask the file owner to unlock it or give you a version you can edit.

Frequently Asked Questions

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

No. Once you close and reopen the file, the undo history is cleared and you cannot recover the deleted sheet. If you think you might need the data later, save a copy of the file before you delete anything.

What if the sheet I want to delete has formulas that other sheets depend on?

Deleting a sheet that other sheets reference will break those formulas. Before you delete, check your other sheets to see if they contain formulas that pull data from the sheet you want to remove. If they do, either update those formulas first or copy the data to a different sheet before deleting.

Does deleting a sheet reduce the file size?

Yes, deleting a sheet removes the data from the file, so the file size shrinks. However, the reduction is usually small unless the sheet contained a lot of data. Hiding a sheet does not reduce file size because the data stays in the file.

Can I delete a sheet if the file is shared with other people?

It depends on the file's sharing settings. If the file owner has restricted editing permissions, you may not be able to delete sheets. Ask the owner to either unlock that ability or give you a version of the file you can fully edit.

What is the difference between deleting and hiding a sheet?

Deleting removes the sheet and all its data from the file permanently. Hiding keeps the sheet and its data in the file but hides it from view. You can unhide a hidden sheet anytime, but you cannot recover a deleted sheet unless you undo when ready.