The fastest way to delete multiple sheets

Right-click on any sheet tab at the bottom of your workbook, then hold Ctrl (Windows) or Command (Mac) and click the other sheet tabs you want to delete. Once all the sheets you want gone are highlighted in white, right-click any of the selected tabs and choose Delete. Excel will ask you to confirm, then remove all of them at once.

This method works whether the sheets are next to each other or scattered across your workbook. You can select as many as you need — Excel has no limit on how many you can delete in one action. The only sheet you cannot delete is the last remaining sheet in the workbook; Excel requires at least one sheet to exist.

If you make a mistake and delete the wrong sheets, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo. This works even if you already closed the file, as long as you have not saved it yet.

Key Takeaways

  • Hold Ctrl or Command while clicking sheet tabs to select multiple sheets, then right-click and choose Delete to remove them all at once.
  • You can select sheets that are not next to each other — the order does not matter.
  • Excel will not let you delete the last sheet in a workbook, so you must keep at least one sheet.
  • Pressing Ctrl+Z or Command+Z when ready after deletion will undo the action and restore all deleted sheets.
  • If you save the file after deleting sheets, you cannot undo the deletion, so be certain before you save.

Selecting sheets that sit next to each other

If all the sheets you want to delete are consecutive — for example, Sheet2, Sheet3, and Sheet4 in a row — you can select them faster by clicking the first one, then holding Shift and clicking the last one. Excel highlights everything in between automatically.

This is quicker than Ctrl-clicking each one individually when you have five or more sheets to remove. After you have the range selected, right-click and choose Delete as usual.

Deleting sheets when you cannot see all the tabs

If your workbook has many sheets, the sheet tabs at the bottom may not all fit on screen. You will see arrow buttons on the left side of the sheet tab area that let you scroll left and right through the list.

Click the arrows to bring hidden sheet tabs into view, then select and delete them the same way. You can also select sheets, scroll to reveal more sheets while holding your selection, and continue clicking to add more sheets to the selection — your previous selections stay highlighted.

What happens when you delete a sheet

When you delete a sheet, Excel removes all the data, formulas, and formatting on that sheet permanently — unless you undo before saving. Any other sheets in the workbook are not affected. If other sheets contain formulas that reference the deleted sheet, those formulas will show a #REF! error.

For example, if Sheet1 has a formula like =Sheet2!A1 and you delete Sheet2, that formula breaks. Before you delete a sheet that other sheets depend on, search your workbook for references to it. You can do this by pressing Ctrl+H (Windows) or Command+H (Mac) to open Find and Replace, then search for the sheet name followed by an exclamation mark, like Sheet2!.

Deleting sheets without confirmation

By default, Excel asks you to confirm before deleting sheets. If you want to skip this confirmation step, you can turn it off in Excel settings, though this is not recommended because it makes accidental deletion easier.

To disable the confirmation: go to File > Options (Windows) or Excel > Preferences (Mac), then find Error Checking or General settings. Look for an option about sheet deletion warnings and uncheck it. After you do this, deleted sheets will disappear without asking — so be extra careful when right-clicking sheet tabs.

Recovering deleted sheets after you save

If you delete sheets and then save the file, those sheets are gone for good — Excel does not keep a backup of deleted sheets inside the file. Your only option is to use your computer's file recovery or version history if you have it enabled.

On Windows, right-click the Excel file, choose Properties, then click Previous Versions to see if an earlier version of the file exists. On Mac, open the folder where the file lives, then go to File > Revert To > Browse All Versions if Time Machine is turned on. These options only work if your system was already backing up files before you deleted the sheets.

Frequently Asked Questions

Can I delete all sheets at once?

No. Excel requires at least one sheet to exist in every workbook. If you try to delete the last remaining sheet, Excel will show an error message and stop you. You must keep one sheet, though you can rename it or clear all its data.

What if I delete a sheet by accident?

Press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo. This works as long as you have not saved the file. If you have already saved, the sheets are gone and you will need to recover an earlier version of the file from your backup or version history.

Do deleted sheets affect formulas in other sheets?

Yes. Any formula that references a deleted sheet will show a #REF! error. Before deleting a sheet, search your workbook for references to it using Find and Replace to see which other sheets depend on it.

Can I delete sheets on a shared workbook?

It depends on your sharing settings. If the workbook is shared through OneDrive or SharePoint, you may need edit permissions to delete sheets. If the file is protected or locked, you may not be able to delete sheets at all — ask the file owner to unlock it first.