How to Delete a Workbook in Excel on Windows and Mac

How-to basics · Updated November 20, 2026

To delete an Excel workbook, close it, then delete its file from the folder where it is stored: use File Explorer on Windows or Finder on Mac. In Excel for the web, delete the file from its OneDrive or SharePoint location. Removing a workbook from Excel’s Recent list only hides the shortcut; it does not delete the file. Before deleting, check that you have the right workbook and save a backup if you might need it later.

What You’ll Need

  • The workbook’s location, such as a folder on your computer, OneDrive, or a SharePoint library.
  • Permission to delete the file. Work or school accounts may restrict deletion, especially for shared files.
  • A backup or another copy if you may need the workbook again. For an important file, confirm the backup opens before removing the original.

Step-by-Step

  1. Confirm that you mean the whole workbook. A workbook is the Excel file, commonly ending in .xlsx, .xlsm, or .xls. Deleting it removes that file, including its sheets, formulas, charts, and other contents. If you only want to remove one tab, do not follow the file-deletion steps: right-click that sheet tab in Excel and choose Delete instead. Deleting a sheet is a different action, and it can also remove data you may need.
  2. Save anything you want to keep. If the workbook is open and has changes, press Ctrl+S on Windows or Command+S on Mac. Check that the save has finished, particularly if the file is on OneDrive or SharePoint. If you want to preserve the contents, use File > Save As to make a separate copy in a location you can identify. Saving a copy is safer than assuming that a version history or cloud recycle bin will always be available.
  3. Close the workbook. Close its Excel window, or use File > Close in Excel. If Excel asks whether to save changes, choose Save if you need to keep them; choose Don’t Save only if you are sure the latest edits are not needed. Closing the workbook makes it less likely that you will delete the wrong item or encounter a file-in-use message. If several workbooks are open, check the title bar before closing each window.
  4. Locate the actual file on Windows. Open File Explorer from the taskbar or Start menu, then browse to the folder containing the workbook. You can also search from the Start menu or use File Explorer’s search box with part of the workbook name. If you are unsure which folder Excel used, open Excel, choose File > Open > Recent, and check the workbook’s location if it is shown. A recent-file entry is a clue to the file’s location, not the file itself.
  5. Check the name and location before deleting. Compare the workbook’s full name and folder with what you intend to remove. If two files have similar names, check the modified date and, when appropriate, open the file to confirm its contents. Do not rely only on an icon or a shortened name in a list. For a shared or synced folder, note that deleting the file may remove it for other people who use that shared copy.
  6. Delete the file in File Explorer. Select the workbook and press Delete, or right-click it and choose Delete. In ordinary local folders, Windows usually moves the file to the Recycle Bin rather than erasing it immediately. Open the Recycle Bin if you want to verify that the correct item was removed. Avoid Shift+Delete unless you specifically intend to bypass the Recycle Bin; that makes recovery more difficult.
  7. Use Finder on Mac, or the storage site for a cloud file. On Mac, locate the workbook in Finder, verify its name and folder, then move it to the Trash using the Finder controls or Command+Delete. For Excel for the web, open the workbook’s OneDrive or SharePoint location in a browser, select the file, and choose Delete. A file in a synced OneDrive folder can also be deleted in Finder or File Explorer, but that deletion may sync to the cloud and to other devices. If the workbook belongs to a shared library, check the sharing arrangements before removing it.
  8. Check the result without confusing it with the Recent list. After deleting, confirm that the file is no longer in its original folder or cloud location. Excel may still display its name under Recent; that entry can remain until refreshed or removed separately. In Excel for Microsoft 365 on Windows, go to File > Open > Recent, right-click the entry, and choose Remove from list if available. This only removes the shortcut from the list; it does not restore or delete the underlying file.

Common Mistakes

Removing a Recent entry instead of deleting the workbook: Excel’s Recent list is a collection of links to files, not a folder of workbook copies. Removing an entry cleans up the list but leaves the file wherever it was saved. To delete the actual workbook, use File Explorer, Finder, OneDrive, or SharePoint to remove the file.

Deleting a worksheet when you meant to delete the file: The Delete command on a sheet tab affects only that sheet, while deleting the workbook file removes the entire Excel document. Conversely, deleting the file is excessive if you only wanted to remove one tab. Check whether you mean a sheet, a workbook, or simply a Recent-list entry before acting.

Picking the wrong copy: Workbooks with names such as Budget, Budget final, and Budget final 2 can be easy to confuse. Verify the folder, full filename, modified date, and contents as needed. OneDrive folders can also contain shortcuts or synced copies, so confirm which location colleagues actually use.

Assuming deletion is permanent—or assuming it is always recoverable: Local Windows deletion usually goes to the Recycle Bin, while Mac deletion usually goes to the Trash. Cloud services may have their own recycle bin and retention rules. Network folders, removable drives, or administrator policies can behave differently. Do not count on recovery as a substitute for a backup.

Forgetting the effect on collaborators: If you delete a workbook from a shared OneDrive or SharePoint location, other users may lose access to that shared file. Deleting a local copy that is not shared has a different effect. Check whether you own the file and whether others rely on it before removing it.

Tips

  • Make a deliberate backup first. If you are uncertain, copy the workbook to a clearly named archive folder or use File > Save As to create a separate copy. Check that the copy is in a different location from the file you plan to delete. A duplicate in the same folder with a nearly identical name can cause confusion later.
  • Use a clear filename and folder structure. If you are cleaning up several workbooks, sort by name or modified date and handle files one at a time. A folder such as Archive or To Review can help distinguish files you are keeping from ones you intend to remove. Do not delete a batch based only on similar filenames.
  • Know whether the file is synced. A green check, cloud icon, or sync status in File Explorer or Finder can indicate that a file is associated with a cloud service. Deleting a synced file may send the deletion to that service. If your goal is only to free local disk space, use the storage service’s option for removing the local download, if available, instead of deleting the cloud file.
  • Check recovery options before emptying the bin. If you delete a file by mistake, stop and look in the Recycle Bin, Trash, or the service’s recycle bin before emptying it. For work or school accounts, an administrator may control retention and restoration. Version history can help with earlier contents, but it is not the same as keeping a separate backup.
  • Keep sensitive files in mind. Moving a workbook to the Recycle Bin or Trash does not necessarily securely erase it. If the workbook contains confidential information, follow your organization’s approved data-handling and deletion procedures rather than assuming ordinary deletion permanently removes every copy.

Troubleshooting

The file will not delete because it is open: Close the workbook in Excel and check whether it is open in another Excel window or on another device. If Excel has stopped responding, close it normally if possible, then try again. Avoid ending a process while unsaved work is open unless you accept losing those changes. A cloud sync process may also be using the file; wait for syncing to finish and retry.

You cannot find the workbook: In Excel, check File > Open > Recent for the name and location. You can also search File Explorer or Finder for part of the filename, including extensions such as .xlsx or .xlsm. If it was opened from an email or browser download, check the Downloads folder. If it was opened online, look in the OneDrive or SharePoint account and library where it was stored, not only on your computer.

Windows or Mac says you do not have permission: Confirm that you are signed in to the account that owns or manages the file. In a work or school folder, ask the owner or administrator for permission instead of trying to work around the restriction. For a shared file, you may be able to remove your own shortcut or access without being allowed to delete the original. The exact choices depend on the service and your access level.

The workbook still appears in Excel after deletion: Excel may retain its Recent entry even though the file is gone. Use Remove from list to clear that shortcut, or wait for the list to update. If opening the entry produces a not-found message, that is consistent with the file having been moved or deleted; it does not necessarily mean the deletion failed. Search the original folder or cloud location to confirm.

You deleted the wrong workbook: On Windows, open the Recycle Bin, select the file, and choose Restore. On Mac, open the Trash and use Put Back if that option is available. For OneDrive or SharePoint, check the relevant recycle bin and restore the file if you have permission and it remains within the service’s retention period. If the item is not there, contact your administrator or check a separate backup. Stop editing or saving over related files until you know which copy is recoverable.

A shared or synced file disappeared for someone else: Check the cloud recycle bin and sharing location, then restore the file if appropriate. Tell collaborators before restoring a duplicate under a new name, since that can create competing versions. If the file is managed by an organization, contact its support team promptly because available recovery time and permissions can vary.

Frequently Asked Questions

Does removing a workbook from Excel’s Recent list delete it?
No. Remove from list only hides the workbook’s shortcut in Excel. To delete the actual file, remove it from its saved location using File Explorer, Finder, OneDrive, or SharePoint.

Can I delete a workbook while it is open?
Close it first. An open workbook can have unsaved changes or be locked by Excel, and cloud syncing can complicate removal. Save any work you want to keep, close the workbook, and then delete the file from its folder.

How do I delete just one sheet instead of the whole workbook?
In desktop Excel, right-click the sheet tab at the bottom of the workbook and choose Delete, then confirm if prompted. This removes that worksheet from the workbook, so save a separate copy first if you may need its data. It does not delete the workbook file.

Will deleting a workbook from OneDrive remove it for everyone?
If you delete the shared file itself from its OneDrive or SharePoint location, other people who use that file may lose access. Deleting only a local shortcut or removing an item from your Recent list is different. Check whether you are removing the shared original or only your own reference.

Can I get a deleted workbook back?
Often, but not always. Check the Windows Recycle Bin, Mac Trash, or the cloud service’s recycle bin first. Recovery depends on where the file was stored, your permissions, and retention settings. Restore a copy or use a separate backup if available, and do not empty the relevant bin until you are sure nothing needs recovery.

Does deleting the workbook remove every copy?
Not necessarily. Other users may have downloaded copies, and cloud services may retain deleted items or versions for a period. Normal deletion is not guaranteed secure erasure. For sensitive data, use the approved process for your device or organization.

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.