How to recover deleted worksheet in Excel

Abby Haines updated on Feb 25, 2019 to File Recovery | How-to Articles

Summary

Did you accidentally delete a worksheet in Excel? This page shows you how to recover deleted Excel sheet data before or after saving without losing any change you have made to the document. And if you accidentally deleted a whole Excel document instead of a single worksheet, you may need EaseUS disk data recovery to retrieve it back.

Accidentally deleted a worksheet in Excel? Read to get a recovery solution!

Working on an Excel document but accidentally deleted a worksheet tab with important information? It's really a disaster!  

At this moment, will you close the Excel file without saving to undo/restore the deleted worksheet or just click the Save button to keep all the changes you made to other worksheets?

It's really difficult to make a decision as each choice will force you to give up something, either the deleted Excel sheet data or the changes you have made to the document.

Recover deleted Excel worksheet without losing any changes

Now the good news is that we can save you from this dilemma. In this page, we'll show you how to recover deleted worksheet in Excel before or after saving without losing any changes. Just read on to get the solution works best for your case. 

Method 1. Recover deleted worksheet in Excel before saving

1) Navigate File > -- Save As to save your working Excel document with a different filename.

2) Re-open your original Excel document.

3) Copy the deleted worksheet from the original file to the new renamed document.

It will help you restore deleted worksheet data to the new renamed Excel document while and keeping all the changes you have made to other worksheets.

Method 2. Recover deleted worksheet in Excel after saving 

But, here, if you have saved your working Excel document, the original files will be overwritten and there is nowhere you can open it to restore the deleted worksheet. In this case, you have to do an extra step to recover the original Excel document via the Previous Version.

1) Open the folder that used to save the Excel document, click the History button. It will tell File History to display all the files contained in the most recent backup of that folder. 

2) Click the Previous button to locate and select the Excel file you want to retrieve and then click the green Restore button to get it back. 

Recover deleted worksheet in Excel after saving via File History

After retrieving the file, you can follow the above steps to recover deleted Excel sheet data. If you are also a Mac user, in addition to the issue shown above, you are also likely to encounter other problems like closing Excel without saving. Thus, it's also necessary to know how to recover unsaved Excel file on Mac in order to avoid data loss.

Recover a whole deleted Excel document with EaseUS data recovery software

Now, we have introduced all the deleted Excel worksheet recovery solutions.

And if you accidentally deleted a whole Excel document instead of a single worksheet, you may need EaseUS data recovery software, a third-party recovery software to retrieve it with all worksheets and contents.

Simple steps for Excel file recovery are as follows:

Step 1. Specify a location

Run EaseUS Data Recovery Software, firstly, you're asked to choose a location to start. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else, and then click "Scan".

select the excel file location

Step 2. Scan data

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. That's part of what the software has found and displayed.

scan excel files

Step 3. Preview and recover

To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". Or, search .xls or .xlsx in the Search box. Select the desired files and click "Recover".

select excel files and recover
 
 

100% of people found this article helful.

 

Frequently Asked Qusetions

1. Why cannot I recover 2GB data for free?

It is recommended to check the version installed is Free or Trial because they are different versions.

Trial has data preview function but cannot save any files, while the Free version enables to recover 2 GB files. The default free space is 500 MB and you may share the product on social media to get another 1.5 GB.

2. Why cannot the recovered files be opened?

A file is saved as 2 parts on the storage device: directory info (which is comprised by file name, time stamp and size info, etc.) and data content.

If the files with original file names and folder structures cannot be opened, one possible reason is the corrupted directory info. There is still a chance to recover the data content with the RAW Recovery method in our software.

3. Why isn't it suggested to recover the files back to the original drive?

The storage structure of the lost files would be altered or damaged by any changes on the drive. If you save the recovered files back to the same drive, the original data structures and data content would be corrupted or overwritten, which causes permanent data loss. So you should prepare another disk to save the files.

4. How can I check whether my data is recoverable or not before purchase?

The Free version helps you save 2GB files to better verify the recovery quality of our product before purchase.

5. How long does it take to scan the drive?

It strongly depends on the capacity of your hard drive and the performance of your computer. As reference,most drive recoveries can be completed in around 10 to 12 hours for a 1-TB healthy hard drive in general conditions.

About Data Recovery Wizard

It's super easy to recover 250+ types of files after deletion, disk formatting and virus infection. Click the links and compare the difference of each version.