Delete a Microsoft Excel Spreadsheet or a Worksheet

How-to basics · Updated November 20, 2026

To delete an entire Excel spreadsheet file on Windows, close it, find it in File Explorer, right-click the file, and choose Delete; it normally goes to the Recycle Bin. To delete just one worksheet, right-click its tab in Excel and choose Delete. These are different actions: deleting a workbook removes the file, while deleting a worksheet removes one tab and its contents from a workbook.

Before either action, check that you have the right file or sheet and save anything you may need. A deleted workbook or worksheet can be difficult or impossible to restore after the available recovery options expire or are cleared. The steps below cover Microsoft 365 on Windows first, with notes for Mac and Excel for the web.

What You’ll Need

  • Access to the workbook in Excel, File Explorer, Finder, or its OneDrive or SharePoint location.
  • Permission to delete the file or edit the workbook. A work or school file may be controlled by its owner or administrator.
  • A backup or a separate copy if you might need the workbook or worksheet later. For a cloud file, check that it has finished syncing before you remove it.

Step-by-Step

  1. Decide whether you mean the whole workbook or one worksheet. An Excel workbook is usually an .xlsx, .xlsm, or .xls file. When you open it, worksheet tabs appear along the bottom of the Excel window. If you only want to remove a tab, do not delete the workbook file: that would also remove every other sheet and the file itself. If the goal is to remove one project, report, or data page but retain the rest, delete only that worksheet.
  2. Save or make a copy before deleting. If the workbook is open, press Ctrl+S on Windows to save it, or choose File > Save. To keep a copy, use File > Save As and save it with a different name or in another folder. On Mac, use Command+S to save; on Excel for the web, changes normally save automatically, but check the status near the workbook name before proceeding. A duplicate is especially useful if the sheet contains formulas, charts, or data that may be referenced elsewhere.
  3. To delete one worksheet in Excel for Windows, select its tab. Click the worksheet tab at the bottom of the workbook. Check the tab name carefully; if tabs are crowded, use the sheet navigation arrows at the lower left to move through them. Right-click the correct tab and select Delete. Excel may display a warning that the sheet will be permanently deleted. Read the warning, verify the sheet name, and confirm only if you are sure. The sheet and its contents, such as cell values, formulas, charts, and sheet-specific formatting, are removed from the workbook.
  4. Use the ribbon if you prefer not to right-click. Select a cell on the sheet you want to remove, then choose Home > Delete > Delete Sheet. The Delete control is in the Cells group on the Home tab; depending on window width, its label may appear as a menu. Check the active sheet before confirming. You can also select multiple adjacent tabs by clicking the first tab and Shift-clicking the last, or select nonadjacent tabs with Ctrl-click, then delete them together. Be cautious: deleting selected sheets removes all of them, not just the currently visible one.
  5. On Mac or Excel for the web, remove a worksheet from its tab menu. In Excel for Mac, Control-click the worksheet tab (or right-click, if your mouse is configured for that) and choose Delete. In Excel for the web, right-click the sheet tab and choose Delete; confirm the prompt. The precise context-menu presentation may differ slightly, but the action is on the worksheet tab, not the browser tab or the workbook file. If the Delete option is unavailable, check whether the workbook structure is protected or whether you only have view access.
  6. To delete the entire workbook on Windows, close it and locate the file. Save any changes, then close the workbook using File > Close or the window close button. Open File Explorer, browse to the folder containing the workbook, and confirm the file name and extension. Right-click the correct file and choose Delete. In most Windows locations, this moves the file to the Recycle Bin rather than erasing it immediately. If the workbook is in OneDrive or a SharePoint-synced folder, deleting the local file may also delete it from the cloud and other synced devices.
  7. Delete a cloud-stored workbook through its storage location when appropriate. For a file in OneDrive, open OneDrive in a browser, sign in to the account that owns the file, find the workbook, select it, and choose Delete. In a SharePoint document library, select the workbook and choose Delete, if you have permission. Confirm the correct location and file before accepting. A deletion in OneDrive or SharePoint generally sends the item to that service’s recycle bin, but retention rules and access may depend on your organization. Avoid deleting a shared workbook if other people still need it; ask the owner or team first.
  8. Confirm the result and know how to undo a mistake. For a worksheet, check that the intended tab is gone and that other sheets remain. If you deleted the wrong sheet and the workbook is still open, immediately press Ctrl+Z on Windows or Command+Z on Mac. Excel’s Undo may restore a just-deleted sheet, but it is not a dependable substitute for a backup, particularly after other actions or closing the workbook. For a workbook file, look in the Windows Recycle Bin, OneDrive recycle bin, or SharePoint recycle bin and use Restore if available. A restored cloud file may return to its original folder.

Common Mistakes

  • Deleting the file when you meant to delete a tab. A workbook can contain many worksheets. Removing the file removes access to the entire workbook, not just the page currently displayed. Open it and use the sheet-tab deletion steps if you only want one sheet gone.
  • Deleting a tab when you meant to remove the whole file. Deleting one worksheet leaves the workbook file and all its other sheets in place. To remove the workbook itself, close it and delete the .xlsx or other workbook file from its folder or cloud library.
  • Choosing the wrong item in a crowded folder. Similar names, file extensions, and date-stamped copies make it easy to select the wrong workbook. Check the complete name and location before deleting. In File Explorer, turn on file name extensions if you need to distinguish an Excel workbook from another file type.
  • Assuming Delete means permanent erasure. Normal deletion often moves an item to a recycle bin, where it can be restored temporarily. Conversely, Shift+Delete on Windows bypasses the Recycle Bin, and emptying a recycle bin may remove an easy recovery route. Do not use either action for a file you may need.
  • Forgetting shared or synced copies. A workbook in OneDrive or SharePoint may be shared with colleagues or synced to several computers. Deleting it can affect other people and devices. Check ownership, sharing, and synchronization before removing it.

Tips

  • Archive instead of delete if you are uncertain. Move the workbook to a clearly named Archive folder, or rename it with an archive date. This removes it from your active working folder without immediately discarding it.
  • Keep a recovery copy outside the location being deleted. A copy in the same synced folder may disappear along with the original if that folder is deleted or synchronization propagates the change. Use a separate approved storage location, especially for important work.
  • Check workbook dependencies before removing a worksheet. Other sheets may contain formulas that refer to it, and charts, named ranges, or summaries may rely on its data. Excel can show reference errors after deletion. If the sheet is only temporarily unnecessary, consider hiding it instead: right-click its tab and choose Hide. Hidden sheets remain part of the workbook and can be unhidden later.
  • Use a specific filename when saving a backup. A name such as Project-Archive-2026-11-03.xlsx is easier to identify than Copy of Book1.xlsx. Do not overwrite the only original while creating a backup; select a different name or folder in Save As.
  • Be careful with workbook protection. If sheet tabs cannot be deleted or the Delete command is disabled, the workbook structure may be protected. On Windows, check Review > Protect Workbook. If protection is on, you may need the password or help from the workbook owner to change the structure. Do not try to bypass protection on a file you do not own.

Troubleshooting

The Delete option is missing or unavailable. Confirm that you selected a worksheet tab rather than a cell or the workbook window. If the workbook is in read-only or view-only mode, request edit access. If the workbook structure is protected, ask its owner for the password or for an unprotected copy. In a shared work or school library, your account may not have permission to delete the file even if you can open it.

Excel says a sheet cannot be deleted because it would leave no visible sheets. Excel requires a workbook to have at least one visible worksheet. If you are removing the last visible sheet, first make another sheet visible or add a new worksheet, then delete the unwanted one. To add a sheet, select the plus button next to the sheet tabs, or use Home > Insert > Insert Sheet.

The workbook is open or Windows says the file is in use. Save and close the workbook in Excel, then try deleting it again. Check for another Excel window or another person using the file. If it is in a synced folder, wait for synchronization to finish and retry. Do not force-close Excel before saving unsaved changes, because that can lose edits.

The file disappeared from OneDrive or a shared folder. Check the relevant recycle bin first. In OneDrive on the web, open Recycle bin, select the workbook, and choose Restore if it is listed. For SharePoint, check the site’s recycle bin or contact its administrator; organization retention settings can affect recovery. If another person owns the file, ask them to restore it. Restore may not be available after the retention period or if the bin was emptied.

You deleted a worksheet and Undo no longer works. If the workbook remains open, try Ctrl+Z on Windows or Command+Z on Mac immediately. If you have already closed it or made further changes, check for a saved copy, OneDrive version history, or your organization’s backup system. For a OneDrive file, open its file menu and look for Version history, if available. Restoring an earlier version can also replace later edits, so review the versions and save a separate copy before restoring when possible.

Frequently Asked Questions

Does deleting an Excel worksheet delete the whole spreadsheet?
No. It removes only that worksheet from the workbook. The workbook file and its remaining worksheets stay in place. Delete the file from its folder or cloud library only when you intend to remove the entire workbook.

Can I recover a deleted Excel workbook?
Often, if it was recently deleted. Check the Windows Recycle Bin for a local file, or the OneDrive or SharePoint recycle bin for a cloud file. Restore it before the relevant retention period ends. A permanently deleted file may require an administrator or backup to recover.

Can I recover a deleted worksheet?
Try Undo immediately while the workbook is open: Ctrl+Z on Windows or Command+Z on Mac. If that no longer works, restore a previous workbook version or open a backup, then copy the missing sheet into the current file if needed.

Will deleting a workbook from OneDrive remove it from other computers?
Usually, yes, if those computers are syncing the same OneDrive location. The deletion can propagate to synced devices and may affect shared users. Check the cloud recycle bin if you need to restore the workbook.

How do I delete an Excel spreadsheet on a Mac?
To delete a worksheet, Control-click its tab and choose Delete. To delete the workbook file, close it, locate it in Finder, Control-click the file, and choose Move to Trash. You can restore it from Trash until you empty it.

Is hiding a worksheet the same as deleting it?
No. A hidden sheet remains in the workbook, and its data and formulas remain available to other sheets. Hide a sheet if you only need to remove it from view; delete it only when you intend to remove its contents.

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.