How to Recover a Deleted Excel Worksheet After Saving
Question details
The user needs to know how to retrieve a specific worksheet tab that was deleted before the Excel workbook was subsequently saved.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- A user accidentally deletes a worksheet within an Excel file and then saves the file, overwriting the document and removing the ability to simply undo the action.
- Observed behavior
- The deleted worksheet is missing from the current saved file, and Excel cannot restore the sheet from the current file alone since the undo history has been cleared.
Stop making further edits to the current workbook immediately to avoid overwriting any remaining temporary files or background AutoRecover backups.
Restore from OneDrive or SharePoint Version History
If your Excel file is saved and synced via OneDrive or SharePoint, you can easily restore a previous version of the workbook from before the deletion occurred.
Cloud storage services keep a detailed history of your file changes. By reverting to an older version of the entire workbook, you can recover the deleted sheet. Note that any modifications made to other sheets after the restored version's timestamp will be lost.
Open your file in Excel. Click on the file name at the top title bar and select 'Version History' from the drop-down menu. Alternatively, navigate to File > Info > Version History.
A panel will open on the right side of your screen displaying earlier versions organized by date and time. Look for a version saved just before you deleted the worksheet.
Click 'Open version' to view it. If it contains your deleted worksheet, click the 'Restore' button at the top of the worksheet to overwrite the current file, or 'Save a Copy' to keep both versions.

Recover Using Excel's AutoRecover Feature
If you do not use cloud storage, Excel's built-in AutoRecover feature might have captured a backup of the file before you saved the deletion.
Restore Using Windows File History
Windows users who have configured File History or system backups can restore the folder containing the Excel file to a previous state.
Prevent and Recover Lost Worksheets Easily with WPS Office
WPS Office offers a powerful, built-in Local Backup Center that continuously saves historical versions of your spreadsheets. This makes recovering a deleted worksheet incredibly simple, even if you have hit save, providing peace of mind without needing cloud subscriptions.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your current spreadsheet document.
- 2. Access the Backup Center: Click on 'Menu' at the top left corner, navigate to 'Backup and Recovery', and select 'Backup Center'.
- 3. Locate the Previous Version: In the Backup Center window, click on 'Local Backup' to view automatically saved historical versions of your files.
- 4. Restore Your Worksheet: Find the version saved just before the worksheet was deleted, double-click to open it, and easily recover your lost data.

Frequently Asked Questions
Can I use the Undo shortcut (Ctrl+Z) to get my deleted worksheet back after saving?
No. Once you save and close an Excel workbook, the undo history is completely cleared. Even if you just save the file while keeping it open, Excel typically clears the undo stack for deleted worksheets, making Ctrl+Z ineffective.
Will third-party data recovery software restore just my deleted worksheet?
Generally, no. Data recovery software operates at the file level. It can help you recover a previously saved version of the entire Excel file from your hard drive, but it cannot extract or repair a single deleted worksheet from within a currently existing file.
Where are Excel AutoRecover files stored by default?
By default, Windows stores Excel AutoRecover files in a hidden AppData folder, typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can verify your specific path by going to File > Options > Save in Excel.




