How to Delete a Worksheet in Excel: Safely and Correctly

How-to basics · Updated November 20, 2026

To delete a worksheet in Excel for Microsoft 365 on Windows, right-click its sheet tab, choose Delete, and confirm if Excel asks. Deletion removes that sheet and its contents from the workbook; it is not the same as hiding a sheet. Before you confirm, check the tab name and make sure you do not need the data, formulas, or charts on it.

What You’ll Need

  • An Excel workbook that you can edit, with the worksheet tab you intend to remove visible or accessible.
  • Permission to change the workbook. If its structure is protected, you may need the password or help from the workbook owner.
  • A saved copy or another reliable backup if the sheet contains information you might need later. Excel’s Undo can help immediately, but it is not a substitute for a backup.

Step-by-Step

  1. Open the workbook and identify the sheet. Open the file in Excel and look along the bottom of the window for the sheet tabs. Read the tab names carefully and click the tab you plan to delete. The selected sheet is usually shown with a highlighted tab or underline. If you have several similarly named tabs, click each one and inspect its contents before deciding. Do not rely only on tab position: sheets can be moved, and a tab next to the one you want may contain important data.
  2. Check for information that depends on the sheet. Review the sheet for data, formulas, charts, tables, or other content you may want to keep. Also consider whether other sheets contain formulas that refer to it. Deleting a referenced sheet can leave formulas with a #REF! error. If you are unsure, save a separate copy of the workbook first, or copy any needed cells into another workbook or sheet. Copying a tab is not required to delete it, but a backup gives you a way to recover content later.
  3. Open the sheet-tab menu. On Windows, right-click the tab for the worksheet you have selected. If you use a trackpad without a right mouse button, use the trackpad’s right-click gesture or press the appropriate context-menu control for your device. In Excel for Mac, Control-click or right-click the sheet tab to open its context menu. Make sure you opened the menu on the intended tab, not on a neighboring one.
  4. Choose Delete. Select Delete from the context menu. Excel may display a warning explaining that the sheet will be permanently deleted. Read the message and confirm only if the displayed sheet is the one you meant to remove. If the sheet is blank, Excel may delete it without showing a confirmation dialog. A blank-looking sheet can still contain formatting, objects, or hidden content, so check before treating it as disposable.
  5. Use the ribbon instead if you prefer. Select the worksheet tab, then go to Home > Delete > Delete Sheet. This performs the same action as the tab menu. Depending on the width of the Excel window, the Delete command may appear in the Cells group or be compressed into a smaller ribbon menu. Choose Delete Sheet, rather than a command that deletes only cells or rows.
  6. Check the workbook after deletion. Look at the remaining tabs to confirm the correct sheet disappeared. Then check key formulas, charts, and summary pages for errors or missing information. If you find that you deleted the wrong sheet, use Undo as soon as possible, as described below. Save the workbook only after you have checked that the remaining content is as expected.
  7. Save when you are satisfied. Press Ctrl+S on Windows, or choose File > Save. On Mac, use Command+S. If the workbook is stored in OneDrive or SharePoint, the change may sync automatically, but check that it has finished saving before closing the file. For a shared workbook, remember that collaborators may see the deletion too.

In Excel for the web, select the sheet tab and open its context menu, then choose Delete and confirm if prompted. The exact menu layout can differ slightly from the desktop app. If you cannot find the command or the workbook has restrictions, open it in the desktop version if you have access and check whether workbook protection is preventing the change.

Common Mistakes

Deleting the wrong tab. Tabs can be close together, and a click on the wrong one can make the wrong sheet active before you open the menu. Check the tab name and, when necessary, inspect the sheet itself before choosing Delete. If tabs are difficult to distinguish, rename sheets with clear labels before making changes.

Confusing delete with hide. Deleting removes the worksheet from the workbook. Hiding keeps it in the file but removes its tab from view. If you only want to simplify the workbook or keep supporting data out of sight temporarily, right-click the tab and choose Hide instead. A hidden worksheet can generally be brought back with Unhide, while a deleted sheet needs Undo or a backup to recover.

Assuming formulas will keep working. A formula on another sheet may refer to the worksheet you remove. Deleting that referenced sheet can change the formula to use #REF!. For example, a summary cell that adds figures from a deleted monthly sheet may no longer calculate. Find and update dependent formulas before deletion when possible, or keep a backup and review important summary sheets immediately afterward.

Deleting a sheet while several tabs are selected. Excel can group worksheets when multiple tabs are selected. Commands may then affect the selected group, not just one sheet. If you see more than one tab highlighted, right-click a single tab or click one tab to clear the group selection before deleting. Avoid making other edits while sheets are grouped, because those edits may be applied to multiple worksheets.

Expecting Undo to work after any amount of time. Undo is most useful right after deletion. Other actions, closing the workbook, or a program interruption can make recovery less straightforward. Do not rely on being able to undo a deletion days later; preserve a backup first if the content matters.

Tips

  • Choose Hide for a reversible tidy-up. If you are not certain a worksheet is no longer needed, hiding it is usually safer than deleting it. You can restore a hidden sheet from the sheet-tab menu by choosing Unhide and selecting the sheet.
  • Keep a dated copy for significant changes. Use File > Save As to create a separate copy before deleting a sheet from a workbook used for reporting, budgeting, or shared work. Give the copy a recognizable name so you can tell it apart from the working file.
  • Consider references and named items. Formulas are not the only possible dependencies. Charts, defined names, data validation, and other workbook features may rely on cells or ranges on the sheet. If the workbook is important, check the parts people use and refresh or repair them after deleting the tab.
  • Delete several sheets deliberately. You can select multiple tabs using Ctrl-click on Windows, then use the tab menu’s Delete command. On Mac, use Command-click to select separate tabs. This deletes all selected sheets, so verify the highlighted tabs first. To select a continuous range, click the first tab and Shift-click the last. If you only mean to remove one sheet, do not use multi-tab selection.
  • Keep a workbook sheet available. Excel does not allow you to delete every worksheet in a workbook. If only one remains, Delete will be unavailable or Excel will prevent the removal. You can keep that sheet, or add another worksheet before deleting the one you no longer want.

Troubleshooting

Delete is missing or unavailable. First check whether the workbook’s structure is protected. In desktop Excel, look under Review for Protect Workbook; if the workbook structure is protected, you may need to turn off that protection using the password. Do not confuse workbook-structure protection with protecting cells on a worksheet: sheet protection controls edits within a sheet, while structure protection can prevent adding, deleting, moving, hiding, or renaming sheets. If you do not know the password, contact the workbook owner rather than trying to bypass it.

The worksheet is hidden and you cannot select its tab. Right-click any visible sheet tab and choose Unhide. Select the worksheet in the dialog and confirm. Once its tab appears, select it and delete it using the steps above. If the Unhide command is unavailable, the workbook may have structure protection enabled, or the sheet may be set to a very hidden state through VBA. Ask the workbook owner or administrator to make it accessible; ordinary sheet-tab controls cannot reveal every very hidden sheet.

You deleted the wrong worksheet. Immediately press Ctrl+Z on Windows or Command+Z on Mac. You can also select Undo from the Quick Access Toolbar or the Edit menu where available. Confirm that the sheet and its contents have returned, then save. If Undo is no longer available, close the workbook without saving only if you are certain that doing so will not discard other changes you need. Otherwise, restore an earlier version from OneDrive, SharePoint, File History, or your organization’s backup system.

Excel reports that the sheet cannot be deleted. Check that at least one worksheet will remain, that the workbook is not protected, and that you have permission to edit the file. In a shared or read-only workbook, request edit access or ask the owner to make the change. If the file is open in a browser and its controls are limited, try opening it in the desktop app. If Excel appears frozen, wait for syncing or calculation to finish before repeating the command; repeated clicks can make it harder to tell what action has completed.

Formulas or charts break afterward. Undo immediately if you want to restore the sheet and reconsider the change. Otherwise, repair the affected formulas or chart data ranges to point to valid remaining cells or sheets. Look for #REF! in key worksheets and check summary totals against a known copy or source. If you created a backup, you can copy the missing data back, but copying a sheet back may not automatically restore every reference exactly as it was.

Frequently Asked Questions

Can I recover a deleted worksheet?
Usually, if you act immediately: use Undo (Ctrl+Z on Windows or Command+Z on Mac). If you have saved, closed the workbook, or performed other actions, recovery may require restoring a prior file version or backup. Excel does not provide a general worksheet recycle bin.

Does deleting a worksheet delete the whole Excel file?
No. It removes one worksheet from the workbook. The other sheets remain. Save the workbook to keep the deletion; otherwise, later changes may not be retained.

What is the difference between deleting and hiding a worksheet?
Deleting removes the sheet and its contents from the workbook. Hiding keeps it in the workbook but removes its tab from the normal view. Choose Hide if you may want the sheet again or simply want a less cluttered tab bar.

Why is the Delete command grayed out?
Common causes include workbook-structure protection, read-only access, or trying to delete the only remaining worksheet. Check the Review tab and your editing permissions, or add another sheet if the workbook has just one.

Can I delete more than one worksheet at once?
Yes. Select multiple tabs with Ctrl-click on Windows or Command-click on Mac, then choose Delete from a selected tab’s context menu. Check which tabs are highlighted before confirming, because every selected sheet will be removed.

Will deleting a worksheet break links or formulas?
It can. Formulas, charts, or other workbook items that depend on the deleted sheet may stop working or show errors such as #REF!. Check important dependent content before deletion and review it afterward.

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.