To delete several worksheet tabs in Excel for Microsoft 365 on Windows, select the tabs together—hold Shift and click to select a consecutive range, or hold Ctrl and click to select separate tabs—then right-click one of the selected tabs and choose Delete. Check the selection carefully first: deleting a sheet removes its contents and can affect formulas that refer to it.
What You’ll Need
- A workbook open in the Excel desktop app. Save a copy first if the sheets contain important information or links.
- The worksheet tabs you want to remove must be visible and selectable. If a sheet is hidden, unhide it before selecting it.
- Permission to change the workbook structure. A workbook protected against structural changes may block deletion.
Step-by-Step
-
Open the workbook and identify the sheets. Find the worksheet tabs along the bottom of the Excel window. Confirm the names of every sheet you plan to delete, and check whether any contain data, charts, or formulas you still need. If you are unsure, save a separate copy with File > Save As before continuing. Deleting a sheet is different from clearing its cells: the entire worksheet is removed from the workbook.
-
Select consecutive tabs with Shift. If the sheets you want to remove sit next to each other, click the first tab. Hold Shift and click the last tab in the range. Excel selects the first tab, the last tab, and the visible tabs between them. For example, to remove the consecutive tabs named January, February, and March, click January, hold Shift, and click March. Check the highlighted tabs before you proceed.
-
Select separate tabs with Ctrl. If the sheets are spread across the tab bar, click the first tab, then hold Ctrl while clicking each additional tab you want to delete. Release Ctrl after selecting the last one. Do not click an unselected tab afterward: that can replace the group selection with just the newly clicked sheet. If you click the wrong tab while holding Ctrl, click it again with Ctrl held to remove it from the selection.
-
Confirm that only the intended sheets are selected. Selected tabs appear highlighted differently from unselected tabs. Read their names from left to right and verify that you have not included a sheet to keep. In desktop Excel, the workbook title area may also show [Group] while multiple sheets are selected. If the selection is wrong, click a single tab to clear the group and start again rather than guessing which tabs are selected.
-
Delete the selected worksheets. Right-click one of the highlighted tabs and choose Delete from the context menu. The command applies to the selected sheets, not just the tab you right-clicked. You can also use the ribbon: select Home > Delete > Delete Sheet. In some ribbon layouts, Delete is shown in the Cells group on the Home tab. If Excel displays a confirmation message, read it and confirm only if the sheet names and selection are correct.
-
Check the workbook after deletion. Make sure the intended tabs are gone and that the remaining sheets still contain the expected information. Look at formulas, charts, and summaries that may have depended on the removed sheets. A formula that referred to a deleted sheet can return a #REF! error. If you spot a problem immediately, use Ctrl+Z on Windows to undo the deletion, then review the selection and dependencies before trying again.
On a Mac: Use Shift-click for a consecutive range, and hold Command while clicking individual tabs to select separate sheets. Right-click, or Control-click, a selected tab and choose Delete. The Home tab also has the Delete Sheet command. Keyboard labels and ribbon layout can differ slightly from Windows.
Common Mistakes
-
Deleting only the active sheet—or selecting more than intended. A normal click selects one tab; a Shift-click selects a range that includes every tab between the endpoints. With Ctrl-click, check each selected tab before deleting. A quick name-by-name review can prevent removing a useful sheet by mistake.
-
Confusing worksheet tabs with other tabs. This process removes sheets along the bottom of the workbook. It does not remove tabs from the Excel ribbon, and it is not the same as deleting rows, columns, or cell contents.
-
Ignoring formulas and workbook features that rely on a sheet. Other sheets may contain formulas referencing the sheet you remove. Charts, summaries, named ranges, or external links may also rely on its data. Check important dependencies first, especially if the workbook is used for reporting or shared with other people.
-
Assuming hidden sheets are included. A hidden worksheet cannot be selected from the visible tab bar. Deleting all the visible tabs does not automatically remove hidden ones. Unhide a sheet if you need to inspect or delete it, and remember that Excel requires at least one visible worksheet in a workbook.
Tips
-
Save a backup before a large cleanup. Use File > Save As to create a copy with a different name. This is useful when removing many sheets, working with a shared workbook, or cleaning up an unfamiliar file. It gives you a fallback if you discover later that a deleted sheet contained something important.
-
Keep sheets grouped only while you need them selected. Excel applies some edits to every selected sheet, not just the active one. After deleting the group, click a remaining tab before making other changes. If you see [Group] in the title area, treat that as a reminder to check which sheets are selected.
-
Use clear names to reduce selection errors. If the workbook has many tabs with similar names, widen the Excel window or scroll the tab bar until you can read them. You can also right-click the sheet navigation arrows near the lower-left corner to display a list of sheet names and locate a tab before selecting it.
-
Delete in smaller groups when you are uncertain. Removing a few clearly identified sheets at a time makes it easier to verify the result and notice broken references. This is safer than selecting a long stretch of tabs when some of the sheets in the middle might still be needed.
Troubleshooting
Delete is unavailable or Excel will not remove the sheets: The workbook structure may be protected. On the Review tab, look for Protect Workbook and turn off workbook protection if you are authorized to do so. Excel may ask for a password. If you do not know it, contact the workbook owner; do not try to bypass protection. Worksheet protection and workbook-structure protection are different, so check that you are addressing the workbook setting.
Excel says you cannot delete the sheet: A workbook must retain at least one visible worksheet. Leave one sheet in place, or unhide another worksheet before deleting the current visible one. If the sheet you want is hidden, right-click a visible tab, choose Unhide, select the hidden sheet, and confirm. If Unhide is unavailable, there may be no ordinarily hidden sheet to show; a sheet set to very hidden requires the workbook owner to change its visibility.
The wrong tabs were selected: Do not choose Delete. Click one tab to clear a multi-sheet selection, then select the right tabs again using Shift or Ctrl. If you already deleted the wrong sheets, press Ctrl+Z on Windows immediately, or Command+Z on a Mac, before making other edits. Undo may no longer be available after closing the workbook or after the undo history has been cleared, which is why a backup is helpful.
Formulas show #REF! after deletion: The formula likely referred to a cell or range on a deleted sheet. Undo the deletion if you need to restore that sheet, then review how the formula is used before deleting it again. If the sheet is no longer needed, update affected formulas to point to valid data or remove obsolete formulas. Check summary sheets and charts as well as the cells that display the error.
You are using Excel for the web: The desktop app provides the grouped-sheet workflow described above. Excel for the web may not offer the same way to select and delete multiple worksheets together. If you cannot select a group of tabs, open the workbook in the Excel desktop app and follow the steps there, or delete the sheets individually using the web app’s tab menu.
Frequently Asked Questions
Can I delete multiple Excel tabs at once?
Yes. Select consecutive tabs with Shift-click or separate tabs with Ctrl-click on Windows, then choose Delete from the context menu. On a Mac, use Command-click for separate tabs.
Does deleting a tab delete the data in it?
Yes. Deleting a worksheet removes the sheet and its contents from the workbook. It is not the same as clearing cells. Save a copy first if you may need the information later.
Can I delete every worksheet in a workbook?
No. Excel requires at least one visible worksheet to remain. You can delete other sheets, but keep one visible sheet in the workbook.
Can I undo deleting multiple sheets?
Usually, press Ctrl+Z on Windows or Command+Z on Mac right away. If you have closed the workbook or the undo history is no longer available, restore a saved copy or use another backup.
Will formulas break when I delete sheets?
They can. Formulas that refer to deleted sheets may show #REF!, and charts or summaries may lose their source data. Review important references before deleting and check the workbook afterward.
Related
- How to Copy an Entire Sheet in Excel: Steps and Tips
- How to Copy a Tab in Excel Without Losing Formatting
- How to Copy a Table in Excel Without Losing Formatting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Merge Zones: 11 Ways to Combine Cells and DataFor a visual heading, select the cells and choose Home > Merge & Center; to combine information without…
- Create an Envelope Template in Word: A Practical GuideIn Microsoft Word for Microsoft 365 on Windows, go to Mailings > Envelopes, enter the delivery and return…
- Excel Import CSV: Does the First Row Become Headers?When you open a CSV file directly in Excel, its first row appears in row 1, but Excel…
- Google Sheets IFERROR: How It Works and When to Use ItIn Google Sheets, IFERROR returns a chosen fallback when a formula produces an error; otherwise, it returns the…
- How to Get Rid of a Dropdown List in Excel QuicklyTo remove a dropdown list in Excel, select the cell or range, go to Data > Data Validation,…
- Google Sheets Data Validation Custom Formula GuideIn Google Sheets, choose the cells, open Data > Data validation, select Custom formula is under Criteria, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.