How to Recover Deleted Sheet in Excel?

Learn how to recover deleted sheet in Excel with two methods on this page. And get tips for the lost/unsaved/corrupted Excel files and data loss prevention.


By Penny / Updated on April 3, 2024

Share this: instagram reddit

Can I get a deleted sheet back in Excel?


I have an Excel file with 15 sheets. But I accidentally 3 sheets in Excel and remain 12 sheets are there. So is there any way to recover deleted sheet in Excel? Thanks.

-A user from SpiceWorks 

Generally speaking, an Excel file usually contains several sheets for different items. So are you wondering how to recover deleted sheet in Excel? Don’t be concerned because you can find answers in the following content.

Two ways to recover deleted sheet in Excel

You can select a targeted solution to recover the accidentally/permanently deleted sheet in Excel. Please pay attention to the corresponding premise for each method.

Method 1. Recover deleted sheet in Excel with AutoSave

What can you do to recover the accidentally deleted sheet in Excel? If you’ve enabled AutoSave, you can recover it using it because this feature could automatically save your editing Excel files at default or customized time intervals.

 Tips: If you haven’t modified your Excel files for a long time, you will not see the recently auto-saved files.

Step 1. Open your Excel program, then click “File” and select the “Info” option.

Step 2. All the recently auto-saved Excel files are listed in the Manage Versions section.


Method 2. Restore previous versions of Excel files

If the above solution cannot help you, it turns out there’s a better way to recover deleted sheet in Excel after save. That is restoring previous versions of Excel files

Ensure you’ve activated System Restore or File History before. If not, this solution is useless for you because you cannot get a history of your previous versions during the editing process.  
Win10/11 users need to turn on the System Protection of the local disk that contains your needed Excel files.
Win8 and above users can go to Control Panel > System and Security to enable File History.

These steps describe how to recover deleted sheet in Excel after save. And it also applies to recovering overwritten Excel files in Windows. 

Step 1. Open Windows File Explorer by pressing the “Win + E” keys.


Step 2. Find the folder that includes your needed Excel files. Then right-click on your located folder and select the “Properties” option.


Step 3. Select an Excel file version after browsing all the listed versions. Remember to save your chosen Excel file to your destination saved path.


Further reading: Recover deleted/lost Excel files with data recovery software

There’s no better way than utilizing professional data recovery to recover deleted/lost Excel files. MyRecover is such a well-received tool. And it is prepared to recover the deleted/lost files from HDD, USB, SD card, and other storage devices. Let’s tap into its key features.  

 Recover Word, Excel, PPT, Photos, Videos, Audio, Emails, Webpages, Compressed files, and other 200+ types of data.
 During scanning, search your desired Excel files by entering their filenames in the search box.
 Get the original path, filename, and format for the deleted files, or wait to find all the deleted and other lost files on your computers after running Quick Scan and Deep Scan automatically.
 Support NTFS, exFAT, FAT32, and ReFS file systems in Windows 7, 8, 10, 11, and Windows Server.

Step 1. Download and install MyRecover on your PC.

Download SoftwareWin 11/10/8/7/Server
Secure Download

Step 2. After loading the disk, hover the mouse over the partition including the Excel files you want to restore. Then click Scan.


Step 3. Search or wait to view all the deleted and other missing files.


Step 4. Go to the Deleted files/Other missing files folder, and click “Recover x files” to get your selected Excel files back. Please save them in a new location.


FQ&A for Excel files

This post shows how to recover deleted sheet in Excel with two solutions. If you need, please consider using data recovery tools like MyRecover to recover deleted/lost Excel files. And there’re other tips for the unsaved/corrupted Excel files.


Penny · Editor
Penny works as an editor at AOMEI Technology, while she's a tester and editor for AOMEI Data Recovery Tools. She enjoys helping users with data recovery issues on Windows and iPhones using simple and practical solutions. Outside of work, she has a strong affection for pets, particularly giant pandas.