How to Recover Deleted Worksheet in Excel

Did you accidentally delete a worksheet in Excel? This page shows you how to recover deleted sheet in Excel before or after saving without losing any change. And if you have mistakenly deleted a whole Excel document instead of a single worksheet, you can resort to EaseUS Data Recovery Wizard to retrieve it back.

Table of Contents

In this article, you can learn to undo deleted sheet in Excel and recover permanently deleted Excel document with data recovery software. At the end of this page, you will see extra guidance on how to recover unsaved Excel files effectively. 

Workable Solutions Step-by-step Troubleshooting
1. Recover deleted worksheet

Method 1. Go to "File" > click "Save as" > re-open the original Excel document > copy...Full steps

Method 2. Open the excel file > click "Home" > click "History" > click "Previous"......Full steps

2. Recover deleted Excel file Download Excel file recovery software > choose a location to scan > preview and recover...Full steps
3. Recover unsaved Excel file Open Excel > click "File" and "Info" > click "Manage Workbook" > choose Recover...Full steps

Working on an Excel document but accidentally deleted a worksheet tab with essential data? It's a disaster! At this moment, you usually have two choices to go on. One is closing the Excel file without saving to restore the deleted worksheet, and the other is clicking the save button to keep all the changes but lose the chance to undo deleted files. It's tough to decide as each choice will force you to give up something.

Now that you are here, you can find solutions to this dilemma.

Recover Deleted Sheet (Data) in Excel 2007/2010/2013/2016

You can learn how to recover deleted sheet and data in Excel without losing any change from the following graphic tutorial.

Method 1. Recover Deleted Worksheet in Excel Before Saving

When you delete a sheet in Excel, there is no Undo option for you. The easiest way to get it back is to close your workbook without saving the changes and then reopen it. The removed worksheet will be there again. But what if you have made many crucial changes to your workbook and you don't want to lose them? How to recover? Here is a solution. 

1. Go to "File", and click "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.

This method will help you restore deleted worksheet data to the new renamed Excel document and keep all the changes you have made to the Excel.

Method 2. Recover Deleted Worksheet in Excel After Saving 

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 can try to recover the original Excel document via the Previous Version.

1. Press Windows + E to open File Explorer and then open the folder that used to save the Excel document.

2. Click the Excel file, click the "Home" tab on the toolbar and then click the "History" button in the Open group. It will tell File History to display all the files contained in the most recent backup of that folder. 

3. Click the "Previous" button to locate and choose the version to recover. Then click the green "Restore" button to undeleted the Excel worksheet. 

Recover deleted worksheet in Excel after saving via File History

You can recover the deleted sheet in Excel through the above two approaches. Suppose you have accidentally deleted the whole Excel document instead of a certain worksheet, how can you get the file back? Don't worry, read the following part, and you'll solve the problem effortlessly. 

How to Recover (Permanently) Deleted Excel Files

You may lose the Excel document due to various reasons, such as unintended deletion, hard drive formatting, device damage/corruption, OS crash, etc. When you face these situations, don't despair. You can use EaseUS Data Recovery Wizard to help you restore the lost Excel file, even though it has been permanently removed. 

Step 1. Select location and click "Scan"

Choose the drive X: or a specific folder on Desktop or somewhere else where you lost the excel files, and then click "Scan".

select a location and click scan

Step 2. Locate your excel files

To quickly find the Excel files from the scan results, click on the "Filter" on the top area, choose "Excel", and click tree view on the left side. Or, search .xls or .xlsx in the Search box. 

scan excel files

Step 3. Preview and recover

You can double click on the Excel file to preview its integrity. Finally, select the desired Excel files and click "Recover".

preview and recover excel files

Extra Guide: How to Recover Unsaved Excel Files

When we talk about excel data recovery, there is also another great need to restore unsaved excel files. It happens a lot to almost everyone. Working day and night for a crucial Excel document, but the power suddenly goes out unexpectedly, your computer shuts down and gives you no time to click the save button. Naturally, the Excel file you are employing disappears.

In this case, you may become extremely anxious about losing the Excel document that contains a lot of data. Calm down. Fortunately, thanks to the AutoRecover feature built-in Excel, you can recover unsaved Excel by following the steps below.

1. Open Excel, click "File" and then click "Info." Click the "Manage Workbook" button and then choose "Recover Unsaved Workbooks" from the menu.

recover unsaved Excel file - 1

2. Then, a window will prompt to show you the whole unsaved Excel files. Select the file to restore and then click "Open" to load the workbook.

recover unsaved Excel file - 2

3. Click the "Save As" button on the yellow bar to recover the worksheet.

This solution won't work if the AutoRecover is disabled. You can enable it in this way:

Open Excel, and click "File" > "Options". In the left navigation pane, clicking "Save". Change the AutoRecover duration in "Save AutoRecover information every xx minutes" and click "OK".

recover unsaved Excel file - 3

Even if you have enabled it, in general, your computer will keep the unsaved temporary files for four days after the latest version. So, to ensure data security, you'd better save the document regularly and back up the saved files to an external hard drive if they are important enough. 

Was This Page Helpful?

author icon

Updated by Brithny

Brithny is a technology enthusiast, aiming to make readers' tech life easy and enjoyable. She loves exploring new technologies and writing technical how-to tips. On her spare time, she loves sharing things about her favorite singer - Taylor Swift on her Facebook or Twitter.

Read full bio

author icon

Written by Roxanne

Roxanne is one of the main contributors to EaseUS and has created multiple posts on digital devices like PCs, Mobile phones, tablets, Mac, etc. She loves to share ideas with people of the same interest.

Read full bio

Product Reviews

TrustScore 4.7 | 323 reviews
  • EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.

    Read More
  • EaseUS Data Recovery Wizard is the best we have seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past.

    Read More
  • EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.

    Read More