How to Recover Deleted Sheet in Excel?

Can I get a deleted sheet back in Excel?

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.

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. 

Notes:✎...

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. AOMEI FastRecovery 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.  

★Tips:

 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 AOMEI FastRecovery on your PC.

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 AOMEI FastRecovery to recover deleted/lost Excel files. And there’re other tips for the unsaved/corrupted Excel files.