Tutorial Guide: 4 Ways to Recover Deleted Excel Sheet Data

Can you recover deleted sheet in Excel?

Excel, a useful application developed by Microsoft, allows us to create and edit worksheets for making graphs, performing calculations, and so on, which boosts our work and study efficiency and organization.However, most of the users may get through the accidental deletion or forget to save the Excel sheet, Just like the following scenario:

“Hi, a couple of days back, I used disk cleanup to delete some old files. Unfortunately, a bunch of important excel sheet data was among them and now I am trying to recover them. And the good way can be suggested to recover? Thanks.”

There’s no denying that it’s so miserable and painful, especially when we spend a large amount of time working on it. Luckily, the Excel deleted sheet can be recovered most of the time.

How do you recover Excel sheet data after deletion?

There are 4 ways listed how to recover Excel sheet deleted on Windows 10, and 11. Keep reading and you would figure out them quickly.

Way 1. Recover deleted Excel sheet data from Recycle Bin

Where are the deleted Excel sheet data going after the deletion? Generally, they are saved in Recycle Bin, which means you could retrieve the deleted files from it. But there are some notes needing pay attention that may cause the Excel sheet data cannot be restored from Recycle Bin:

• If you delete the Excel sheet data with the shortcut Shift + Delete.
• If you empty your Recycle Bin regularly.

Step 1. Open Recycle Bin.

Step 2. Find your deleted Excel sheet files, and then right-click it. Choose Restore. (You can also search the filename or the content of the Excel in the search box to locate.)

Unable to find the Excel sheet in Recycle Bin? Try the next solution.

Way 2. Recover deleted Excel sheet data in File History

File History can be used to restore deleted Excel sheet data. But it is only available if you enabled the feature before, otherwise, you’ll only get a warning saying that there’s no backup to restore. Now follow me to know how to recover an Excel spreadsheet that was deleted in this way.

Step 1. Start the Control Panel, click System and Security.

Step 2. Click File History.

Step 3. Then go to Restore personal files. ( It will show Turn off if you enabled this feature before)

Step 4. Find your deleted Excel file, then click the Recycle icon at the bottom of this window to restore your deleted Excel sheet data.

Apart from using File History, you can also use Restore Previous Versions. If you enabled Restore point or File History before, then this operation can work out.

Step 1. Use shortcut Win + E to open the File Explorer.

Step 2. Locate the folder in which you previously saved the deleted files. Right-click the folder and click Restore previous versions.

Step 3. Then select the version according to the time and then select Restore. Finally, your file will be back. Save it immediately this time.

Note: If File History isn't working, you can use other ways to recover deleted excel sheet data. 

Way 3. Recover deleted Excel sheet data by using Excel Autosave and AutoRecover feature

To recover deleted excel sheet data, the feature AutoSave and AutoRecover are also workable. They can automatically save the new document created just now but hasn’t been saved and recovered the last saved version.

Step 1. Start the Excel on your PC, and click File.

Step 2. Go to Info, find Manage Workbook, then click Recover Unsaved Workbooks.

Step 3. Then your unsaved files will be shown in the pop-up window. Select the files you want to restore and then click on Open.

Step 4. Don’t forget to click File and then go to Save As to save your files carefully.

Note: If you could not find the last version, that means some options in this feature didn’t be enabled. We can enable them in case of the next data loss.

Step 1. Open Excel and then click File > Options.

Step 2. Click Save in the left panel.

Step 3. Tick Save AutoRecover information every xx minutes, and minimize the interval to 1 or any length you need or prefer. Then Tick Keep the last AutoRecovered version if I close without saving.

Way 4. Rapidly & easily recover deleted Excel sheet data with AOMEI Data Recovery

There is also a great option to recover deleted Excel sheet data that will not only save you a lot of time but also effectively restore your deleted Excel sheet data without any corruption. That's AOME Data Recovery for Windows, a professional and simple tool that can get you out of trouble.

★Tips:

 MyRecover could restore your Excel sheet data rapidly with just a few clicks, inferring that the operation is fairly user-friendly.

 Apart from restoring deleted Excel sheet data, it is also accessible to recover deleted videos, pictures, PPT, PDF, etc. 

 It supports many Windows versions from Windows 7 to Windows 11 as well as Windows Server.

Get a free one to restore deleted Excel sheet data immediately!

Step 1. Install and run MyRecover. And then hover the mouse over the drive, and click Scan.

Step 2. Wait for the software to scan and list all the deleted and missing files. During the process, you could directly select files to recover.

Step 3. Go to Deleted files. Select the Excel files you need and then click Recover x files. 

Conclusion

This post introduces 4 ways to recover deleted Excel sheet data, such as searching in Recycle Bin, using File History, taking advantage of Autosaving and so on. If the ways are not working for you or you are looking for a quick fix, then AOMEI Data Recovery is your great choice.

By the way, we can learn such a lesson from this accidental deletion, indirectly reflecting the significance of backup. Whether it's a phone backup or a Windows backup, they always play a crucial role when we encounter data loss. For this reason, it’s fairly necessary to back up your PC with software that is devoted to developing backup, AOMEI Backupper. Download it and explore much more surprises in it.