To delete a worksheet tab in Excel for Microsoft 365 on Windows, right-click the sheet tab at the bottom of the workbook, choose Delete, and confirm if Excel asks. This removes the worksheet and its contents, not just the tab label, so check that you have the right sheet and save a backup first if its data might matter. The steps below cover desktop Excel, with notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook open in Microsoft 365, Excel for Mac, or Excel for the web.
- Permission to change the workbook. If its structure is protected, you may need the password to remove a sheet.
- A saved copy or another way to restore the workbook if you are unsure whether the sheet is still needed. This is especially useful for shared or important files.
Step-by-Step
- Find the worksheet tab. Look along the bottom of the Excel window for the row of sheet names, such as Sheet1 or Sales. These are worksheet tabs. They are different from ribbon tabs such as Home and Insert. If the sheet tabs are not visible, see Troubleshooting below before assuming the sheet is missing.
- Check the sheet before removing it. Click the tab you are considering deleting and review its contents. Look for data, formulas, charts, notes, or information that other sheets may use. If you are not certain, keep the sheet for now, make a copy of the workbook, or rename the sheet temporarily so you can verify its purpose.
- Save a recoverable copy if needed. For a local workbook, choose File > Save As and save a separate copy before making a substantial change. For a file stored in OneDrive or SharePoint, check that version history is available and that you can access it. A backup matters because deleting a worksheet removes its contents, and later edits can make a simple Undo less suitable.
- Open the sheet-tab menu. In Windows desktop Excel, right-click the tab you want to remove. If you use a touchpad or do not have a right mouse button, use the equivalent two-finger or secondary click. In Excel for Mac, Control-click or right-click the tab. In Excel for the web, right-click the tab as well; available menu options can depend on your permissions.
- Choose Delete. Select Delete from the menu. In Windows desktop Excel, you can also select the worksheet first and use Home > Cells > Delete > Delete Sheet. Make sure you choose Delete Sheet, not a command that only clears cell contents. The ribbon route also deletes the worksheet itself.
- Read and confirm the warning. If the worksheet contains data, Excel normally warns that the sheet will be permanently deleted and asks you to confirm. Check the sheet name in the context of your selection, then choose Delete only if you are sure. A blank worksheet may be removed without a warning. If Excel says it cannot delete the sheet, check whether the workbook structure is protected.
- Verify the result and save. Confirm that the tab is gone and that the remaining sheets still look as expected. Check formulas, charts, and other sheets that may have referred to the deleted worksheet. Save the workbook when you are satisfied. If you removed the wrong sheet and have not made other changes, use Ctrl+Z on Windows or Command+Z on Mac immediately. In Excel for the web, use the Undo button or the available keyboard shortcut.
For a faster alternative on Windows, select the sheet tab and use Home > Cells > Delete > Delete Sheet. Excel does not provide a single universal keyboard shortcut for deleting a worksheet that bypasses confirmation, so the tab menu or ribbon command is easier to verify before you commit. On Mac, use the tab’s context menu or the appropriate Delete command available in the ribbon.
Common Mistakes
- Confusing a worksheet tab with a ribbon tab. Home, Insert, and Data are ribbon tabs at the top. A worksheet tab is a named sheet at the bottom. The instructions here delete a worksheet, not a ribbon tab or a tab in another application.
- Thinking Delete only removes the visible tab. It removes the whole worksheet, including the cells and objects on it. If you want to keep the data but temporarily remove the tab from view, use Hide from the sheet-tab menu instead. You can later use Unhide to show a hidden sheet again.
- Deleting a sheet that other content depends on. Formulas that refer to a deleted worksheet can show a #REF! error. Charts, summaries, named ranges, or external workbooks may also rely on that sheet. Review important dependencies before deleting it, particularly in a workbook used for reporting.
- Confirming without checking the active tab. If several tabs have similar names, pause and read the selected tab name before choosing Delete. Selecting the wrong worksheet can remove useful information even if the warning appears exactly as expected.
- Assuming a hidden sheet has been deleted. A hidden worksheet is still in the workbook. If you cannot see a sheet you expected to remove, right-click a visible tab and choose Unhide, if available. Select the hidden sheet, unhide it, and then delete it if that is truly what you intend.
Tips
- Hide first when your decision is reversible. Hiding is a useful test if you are cleaning up a workbook but are unsure whether a sheet is obsolete. Right-click the tab, choose Hide, and check whether the workbook still works as expected. To restore it, right-click another visible tab, select Unhide, and choose the sheet.
- Use clear names before making changes. Rename sheets with descriptive labels such as Archive 2024 or Old Import before reviewing them. A meaningful name makes it easier to distinguish the intended sheet from similarly named tabs. Renaming does not protect data, so still make a copy when appropriate.
- Review formulas after deletion. Use Excel’s error indicators and check key totals or reports on the remaining sheets. A deleted-sheet reference may become #REF!, but a workbook can also contain formulas that still calculate while no longer representing the intended data. Checking important outputs is safer than looking only for visible errors.
- Take extra care with shared files. If other people are editing the workbook, let them know before removing a sheet that could be part of their work. Confirm that changes have synced before closing the file. If the workbook is stored in OneDrive or SharePoint, version history may let you restore an earlier version, subject to your access and organization settings.
- Remember that deletion and hiding solve different problems. Delete a worksheet when you are confident it is no longer needed. Hide it when you want to keep its data in the workbook but reduce clutter for other users. Neither option is a substitute for a separate backup of important information.
Troubleshooting
Delete is unavailable or Excel refuses to remove the sheet: The workbook structure may be protected. In Windows desktop Excel, check Review > Protect Workbook. If workbook protection is on, turn it off using the required password, then try deleting the sheet again. Sheet protection and workbook-structure protection are different: unprotecting cells on a worksheet may not give you permission to delete the worksheet. If you do not know the password, ask the workbook owner or administrator rather than trying to bypass the protection.
You cannot see the worksheet tabs: The tab strip may be hidden, or the horizontal scroll control may be taking up space. In Windows desktop Excel, open File > Options > Advanced, find the display options for the workbook, and check Show sheet tabs. On Mac, open Excel settings or preferences and look under the workbook’s view options for sheet-tab display. In Excel for the web, widen the browser window or check the lower edge of the workbook for the tab strip. If tabs are visible but a particular sheet is absent, it may be hidden rather than deleted.
You deleted the wrong sheet: If the deletion was your most recent action, use Undo right away: Ctrl+Z on Windows or Command+Z on Mac. Check that the sheet and its data return before continuing. If you have made many later changes, closed the workbook, or Undo is unavailable, look for a previous version through File > Info > Version History where supported, or use the version history for the file in OneDrive or SharePoint. Restoring an earlier version can also undo other people’s or your later edits, so review the version and coordinate with collaborators first.
Excel gives no warning, but the sheet disappears: Excel may remove a blank worksheet without showing the data-loss confirmation. If the tab is gone, use Undo immediately if you did not mean to delete it. If it was the wrong sheet and Undo is no longer available, use a backup or version history rather than creating a blank replacement and assuming the original contents will return.
The deleted sheet causes errors elsewhere: If formulas now show #REF!, Undo if possible, or restore a version or copy that still contains the sheet. If deletion was intentional, inspect dependent formulas and update them to point to valid data. Also review charts and reports. Avoid simply replacing every #REF! with a guessed value; the correct repair depends on what the formula was meant to calculate.
Frequently Asked Questions
Does deleting a tab in Excel delete the worksheet data?
Yes. Deleting a worksheet tab removes the worksheet and its contents from the workbook. Choose Hide instead if you want to keep the data but not display the tab.
Can I delete more than one worksheet at once?
Yes. In desktop Excel, select a group of adjacent sheet tabs with Shift-click, or select nonadjacent tabs with Ctrl-click on Windows. On Mac, use Command-click for nonadjacent tabs. Then use the tab context menu’s Delete command and confirm carefully. Grouped sheets can be easy to overlook, so check which tabs are selected before deleting.
Can I delete the only worksheet in a workbook?
No. Excel requires a workbook to retain at least one visible worksheet. If the workbook has only one sheet, the delete command will not remove its last visible worksheet. You can clear its contents or create another sheet first, depending on your goal.
Can I get a deleted worksheet back?
Often, if you act quickly: use Undo before making other changes. If Undo is no longer available, recovery depends on whether you have a saved copy, AutoRecover data, or accessible version history. A restored earlier version may discard edits made after that version.
Is the process different in Excel for the web?
The basic method is similar: right-click the worksheet tab and choose Delete, then confirm if prompted. Some menu options and recovery features differ from desktop Excel, and your permissions can limit what you can change. If the menu does not offer deletion, check with the workbook owner.
What if I only want to remove the tab but keep its information?
Excel does not provide a way to delete a worksheet’s tab while keeping that worksheet’s data in place. Hide the sheet to remove it from the visible tab row, or copy its contents to another sheet or workbook before deleting it.
Related
- How to Copy and Paste Only Filtered Data in Excel Safely
- How to Copy and Paste an Excel Table in Yahoo Mail
- Copy the Same Date Down an Excel Column Without Auto-Fill
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- SUMIF Checkbox in Google Sheets: Sum Checked RowsIf your checkboxes are in A2:A20 and the values to add are in B2:B20, use =SUMIF(A2:A20,TRUE,B2:B20) to total…
- Excel Date Month and Year Only: Format or Convert?To display an Excel date as month and year only, select the date cells, press Ctrl+1, choose Number…
- Remove All Formatting in Word Without Losing TextTo remove formatting from a Word document, save a copy, press Ctrl+A on Windows (Command+A on Mac), then…
- Alternating Color Rows in Excel: 2 Easy MethodsTo add alternating color rows in Excel, select your data and choose Insert > Table, then pick a…
- How to Make Columns in Word Without a Table: A GuideTo make columns in Word without a table, select the text you want to split, then choose Layout…
- Excel Data Validation Restrictions and Their LimitsExcel data validation can restrict what users enter in selected cells—for example, to a number range, a date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.