Delete Multiple Tabs in Excel at Once: How It Works

How-to basics · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, select the worksheet tabs you want to remove—use Shift-click for a consecutive run or Ctrl-click for separate tabs—then right-click a selected tab and choose Delete. Excel asks you to confirm; check the selection carefully because deleting a sheet removes its contents, formulas, and sheet-specific settings.

What Excel means by multiple tabs

Excel calls the worksheet tabs along the bottom of a workbook sheet tabs. Each tab represents a worksheet, and a workbook can contain many of them. Deleting several tabs at once means selecting several worksheets and issuing one Delete command. It does not mean closing several open Excel windows or removing several files.

The selection matters: Excel treats multiple selected sheets as a group. A grouped selection lets you perform certain actions on several sheets together, including deleting them. If you have accidentally selected a group, other edits—such as typing into a cell or changing formatting—may also affect every selected sheet. For that reason, confirm which tabs are highlighted before you proceed.

Delete consecutive worksheet tabs

Use this method when the sheets to remove sit next to each other in the tab bar. For example, if a workbook has tabs named January, February, March, April, and Summary, you can select February through April as one range.

  1. Click the first worksheet tab in the range.
  2. Hold Shift and click the last tab in the range. Excel selects the first tab, the last tab, and all tabs between them.
  3. Right-click one of the selected tabs and choose Delete.
  4. Read the confirmation prompt and verify that the selected worksheets are the ones you intend to remove. Confirm the deletion.

On Windows, the right mouse button opens the tab’s context menu. You can also use the ribbon: with the sheets selected, choose Home > Delete > Delete Sheet. The right-click menu is usually quicker, while the ribbon path can be easier to find if you do not use context menus often.

Delete nonconsecutive tabs

When the sheets are separated by tabs you want to keep, select them individually instead of selecting a range. For example, to remove January, March, and May while keeping February and April:

  1. Click January’s tab.
  2. Hold Ctrl and click March, then May. Keep Ctrl held as you click each additional tab.
  3. Check the highlighted tabs. February and April should not be selected.
  4. Right-click one of the selected tabs, choose Delete, and confirm after checking the prompt.

This is also useful for cleaning up sheets with names that do not follow a consistent sequence, such as old drafts scattered between current reports. Do not click a tab without the modifier key while building a selection: a normal click changes the active sheet and can replace the group you had selected.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. On a Mac, Shift-click selects a consecutive range. To add or remove individual tabs from a selection, use Command-click rather than Ctrl-click. You can open the tab menu with a right-click or Control-click, then choose Delete. Menu wording and prompt details can differ slightly by platform or update, but the essential action is to select the sheets and use the sheet deletion command.

Excel for the web has worksheet tabs and deletion controls, but its interface and available selection behavior can differ from the desktop app. If your browser or operating system intercepts a modifier-key click, use the web app’s available tab-selection options or open the workbook in the desktop app for a larger, complex selection. After selecting sheets in the web app, use the tab context menu if it offers Delete, and check the confirmation before proceeding.

These steps concern worksheet tabs within one workbook. Deleting a worksheet does not delete the workbook file, and it does not remove a tab from a different workbook. If you meant to close workbooks, use Excel’s window or file controls instead.

Check the selection and protect important data

Deleting worksheets can remove more than visible cell values. A sheet may contain formulas, charts, tables, named ranges, notes, print settings, or data needed by another sheet. Formulas elsewhere in the workbook that refer to a deleted sheet can return reference errors. A tab that looks like an old draft may still feed a summary or dashboard.

Before confirming, take a moment to review the tab names and consider whether any formulas or reports depend on them. For valuable workbooks, save a separate copy before cleanup. You can also inspect formulas and links in the workbook, or move needed information to a retained sheet before deleting its source. A backup is especially useful when removing a large group or working with a workbook whose structure you did not create.

  • Confirm that only the intended tabs are highlighted.
  • Check whether a summary sheet, chart, or formula refers to a sheet you plan to remove.
  • Save a copy if you might need to recover the worksheets or their contents later.
  • After deletion, review important totals and reports for errors or missing data.

Excel may show a warning before deleting sheets. Treat that prompt as a final check, not as proof that the sheets are unimportant. Depending on the situation and Excel version, you may be able to reverse a recent deletion with Undo or Ctrl+Z on Windows; Command+Z is the Mac equivalent. Do not rely on Undo as your backup plan, particularly after closing the workbook or making further changes.

Why Delete may be unavailable

If Delete is disabled or Excel will not remove a sheet, first check workbook protection. A workbook protected with a structure password can prevent sheets from being deleted, moved, hidden, or renamed. If you have authorization and the password, use Review > Protect Workbook to turn off the structure protection, then try again. Do not attempt to bypass a password; ask the workbook owner for access.

A workbook must retain at least one visible worksheet. Excel will not let you delete the final visible sheet. If you need to replace all the current sheets, first create or unhide a replacement sheet, then delete the others. To reveal a hidden sheet, right-click a visible tab and choose Unhide, select a sheet, and confirm. A very hidden sheet, often created through VBA, may not appear in the ordinary Unhide list and may require the workbook’s owner or developer to reveal it.

Also distinguish hiding from deleting. If a sheet is hidden, it is not available for ordinary tab selection and will not be removed just because you selected the visible tabs. Unhide it first if you intend to delete it. If the workbook is shared, read-only, or restricted by organizational permissions, your access may also limit structural changes; ask the owner or save an authorized editable copy.

Deleting sheets versus hiding or clearing them

Deleting is appropriate when you are sure the worksheets are no longer needed. It removes each selected sheet from the workbook, including its data and layout. It can also break formulas and references that rely on the removed sheet. By contrast, hiding a sheet leaves its contents in the workbook and can be reversed later. Hiding is often better for archived detail that should not appear in everyday navigation.

Clearing contents is another option, but it is not the same as deleting a sheet. Selecting cells and clearing them can leave the worksheet, formatting, objects, and other settings in place. That may suit a reusable template, but it can also leave behind structures or formatting that confuse later users. Choose based on the goal:

  • Delete: remove an unnecessary worksheet and its contents from the workbook.
  • Hide: keep a worksheet available for later use while removing it from the visible tab row.
  • Clear: retain the worksheet itself but remove selected cell contents or formatting.
  • Move or copy: preserve a sheet in another workbook before removing it from this one.

Common selection mistakes

The most frequent error is selecting a range when intending to select isolated sheets. Shift-click includes every tab between the two clicked tabs, even if some of those middle sheets should remain. For scattered tabs, use Ctrl-click on Windows or Command-click on Mac. Another mistake is confusing the active sheet with the full selection: the active tab may look different from the other selected tabs, so inspect the entire tab row before deleting.

After a deletion, Excel may switch to a neighboring worksheet. That does not mean only one sheet was deleted; check the tab row and workbook contents. If the wrong sheets were removed and Undo remains available, use it promptly. If not, restore from a saved copy or another version of the workbook. Avoid making additional edits before deciding how to recover, since they can complicate restoration.

Frequently Asked Questions

Can I delete several Excel sheets without selecting them one by one?
Yes. For a consecutive group, click the first tab and Shift-click the last. For separate sheets, click the first and Ctrl-click each additional tab on Windows, or Command-click on Mac. Then issue Delete once for the selection.

Can I delete all the tabs in a workbook?
No. Excel requires a workbook to retain at least one visible worksheet. Create or unhide a replacement first if you need to remove all the existing visible sheets.

Will deleting a worksheet break formulas?
It can. Formulas or charts that depend on a deleted sheet may show errors or lose their source data. Check important reports and references before confirming, and keep a copy if you may need the original structure.

Can I undo deleting multiple sheets?
Often, a recent sheet deletion can be reversed with Undo—Ctrl+Z on Windows or Command+Z on Mac. Availability can depend on what you did afterward and the Excel environment, so save a backup rather than relying on Undo.

Why can’t I delete a worksheet tab?
The workbook structure may be protected, the file may be read-only, or the sheet may be hidden rather than selected. A workbook also cannot be left with no visible worksheet. Check those conditions and contact the owner if you do not have permission to change the workbook.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.