How to Delete Multiple Worksheets in Excel

How-to basics · Updated November 20, 2026

To delete several worksheets in Excel for Microsoft 365 on Windows, select their sheet tabs by holding Ctrl and clicking non-adjacent tabs, or select a range with Shift-click. Right-click one of the selected tabs and choose Delete, then confirm if prompted. Save a copy first if you may need the sheets later: deleting removes each selected worksheet and its contents from the workbook.

You can delete adjacent or separate worksheets in one action. Before you do, check that the tabs you selected are the ones you intend to remove, and consider whether formulas, charts, or other sheets depend on them.

What You’ll Need

  • The workbook open in the Excel desktop app, with permission to edit it.
  • A saved backup or a duplicate of the workbook if the deleted sheets might be needed again.
  • The workbook password, if its structure is protected and Excel asks you to unprotect it.

The instructions below are for Excel for Microsoft 365 on Windows. Excel for Mac uses Command-click rather than Ctrl-click to select separate tabs. Excel for the web may not support selecting multiple worksheet tabs together; if you cannot multi-select there, open the workbook in the desktop app.

Step-by-Step

  1. Save the workbook and identify what can be removed. If you are unsure, choose File > Save As and save a separate copy before deleting anything. Review the worksheet names and, where relevant, check formulas or charts on other sheets that use data from the sheets you plan to remove. Deleting a worksheet is different from clearing its cells: the worksheet tab itself, along with its contents and sheet-level objects, is removed.
  2. Find the worksheet tabs. They usually appear along the bottom of the Excel window, near the horizontal scroll bar. If you have many tabs, use the navigation arrows at the lower-left to scroll through the tab strip. Clicking a tab once makes it the active worksheet; that action alone does not select a group.
  3. Select adjacent worksheets as a group. Click the tab of the first sheet in the range. Hold Shift and click the tab of the last sheet in the range. Excel selects the tabs between them, including both endpoints. For example, if the order is January, February, March, April, and you Shift-click April after selecting February, February through April are selected. Check the visible selection before continuing.
  4. Select separate, non-adjacent worksheets. Click the first tab, then hold Ctrl and click each additional tab you want to include. On a Mac, hold Command instead of Ctrl. Do not click tabs you want to keep: Ctrl-clicking or Command-clicking a selected tab can remove it from the selection. If you need to change the group, add or remove tabs with the same modifier before deleting.
  5. Check that the selection is correct. Selected worksheet tabs are highlighted differently from unselected tabs, though the exact colors depend on the Office theme. Look at each selected name, especially if the tabs are close together or you have scrolled through a long workbook. Avoid using Select All Sheets unless you have verified the result carefully; Excel must retain at least one worksheet in the workbook.
  6. Delete the selected worksheets. Right-click one of the selected tabs and choose Delete. On a Mac, Control-click or right-click the selected tab and choose Delete. You can also use the ribbon: select the tabs, then choose Home > Cells > Delete > Delete Sheet. The command applies to the selected group, not just the tab you right-clicked.
  7. Confirm and check the workbook. If Excel displays a warning that the sheets will be permanently deleted, read it and choose Delete only if the selection is correct. Excel may show a warning for each sheet or a confirmation for the group, depending on the action and version. Check that the intended tabs are gone and that the remaining sheets still look right. Save the workbook when you are satisfied.

If you delete a sheet by mistake, try Undo immediately: press Ctrl+Z on Windows or Command+Z on Mac. Undo may restore the deleted sheet if the action is still in Excel’s undo history. It may not be available after closing the workbook or performing other actions that clear the undo history, so a backup is the safer recovery plan.

Common Mistakes

  • Clicking instead of modifier-clicking. A normal click activates a different tab and replaces the current selection. Hold Ctrl on Windows or Command on Mac while clicking each separate tab you want to add.
  • Choosing the wrong range. Shift-click selects every tab between the first and last, not just those two. If you want only two sheets with other tabs between them, use Ctrl-click or Command-click instead.
  • Assuming a tab is only hidden. Delete removes the worksheet; it does not hide it. If you only want it out of sight for now, choose Hide from the tab’s right-click menu instead.
  • Ignoring links and references. Formulas on other sheets that refer to a deleted sheet may show #REF! or stop returning the intended result. Charts, named ranges, and other workbook elements may also be affected.
  • Deleting the wrong sheets because tabs are off-screen. Scroll the tab strip and verify names before running Delete. The selected sheets can include tabs that are not currently visible in the tab area.

Tips

  • Use a copy when the deletion is substantial. A duplicate lets you compare the original and revised workbooks or retrieve a sheet later without relying on Undo.
  • Keep a record of the selection. If the workbook has many similarly named tabs, note the sheet names you plan to remove before selecting them. This reduces the chance of including a needed worksheet by mistake.
  • Review dependencies first. Search for the sheet name in formulas on important worksheets, and check charts or summary pages that draw on its data. If you are not sure whether a sheet is still used, keep it or hide it until you can confirm.
  • Choose Hide when removal is not necessary. Hiding preserves the worksheet and its data, and you can make it visible again later. Use Delete only when you want the sheet removed from the workbook.
  • Save after checking. Saving commits the revised workbook to its file. If you saved a separate copy before the change, keep the original until you have verified that the new version works as expected.

Troubleshooting

Delete is unavailable or Excel will not remove the sheets: The workbook structure may be protected. Check the Review tab for Protect Workbook. If workbook structure protection is on, turn it off using the password; you need the password or help from the workbook owner if you do not have permission. A read-only workbook may also prevent changes, so save an editable copy if you are authorized to do so.

You cannot select more than one tab: Confirm that you are holding Ctrl while clicking each tab on Windows, or Command on Mac. For a continuous block, select the first tab and Shift-click the last. If you are using Excel for the web and multi-selection is unavailable, open the file in Excel for Microsoft 365 on Windows or Mac and make the selection there.

A worksheet you need is not shown in the tab strip: It may be hidden. Right-click a visible worksheet tab, choose Unhide, select the sheet, and choose OK. Once it appears, you can include it in a deletion selection. If Unhide is unavailable or a sheet is very hidden because of a workbook customization, ask the workbook owner to make it visible; do not change settings you do not understand.

Excel warns that the selected sheet will be deleted: This warning is expected. Cancel if you are not certain which tabs are selected, then inspect the selection again. If you intentionally selected the sheets, confirm the deletion. Remember that formulas referring to a deleted sheet may need to be repaired afterward.

The deleted sheet did not come back with Undo: Try Ctrl+Z on Windows or Command+Z on Mac immediately, before doing other work. If Undo is unavailable, check whether you have a saved backup, a previous version through OneDrive or SharePoint version history, or an organization-managed backup. Recovery options depend on where the workbook is stored and its save settings.

Frequently Asked Questions

Can I delete non-adjacent worksheets at the same time?

Yes. On Windows, hold Ctrl and click each worksheet tab to include it in the selection, then right-click a selected tab and choose Delete. On Mac, use Command-click. Verify the selected names before confirming.

Can I delete all the worksheets in a workbook?

No. An Excel workbook must contain at least one worksheet, so Excel will not let you remove every sheet. Keep one worksheet, or create a replacement before deleting the other sheets.

Will deleting a worksheet break formulas?

It can. Formulas on other sheets that refer to the deleted worksheet may return #REF! or no longer calculate as intended. Check important formulas and charts before deletion, and repair any references afterward.

Can I recover a worksheet after deleting it?

Try Undo right away with Ctrl+Z on Windows or Command+Z on Mac. Recovery is not guaranteed if Undo is no longer available. A backup or a previous file version may be needed, so save a copy first when in doubt.

Is hiding a worksheet the same as deleting it?

No. Hiding keeps the worksheet and its data in the workbook but removes its tab from view. Deleting removes the worksheet from the workbook. Choose Hide if you may need the sheet again.

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.