How to Recover Deleted Worksheet in Excel

You can learn how to undo deleted sheets in Excel and recover permanently deleted Excel documents using data recovery software, as well as recover unsaved Excel files effectively.

Working on an Excel document, you may accidentally delete a worksheet tab with essential data, leaving you with a difficult decision. You can either close the Excel file without saving to restore the deleted worksheet, or click the save button to keep all changes, but lose the chance to undo the deletion. Each choice comes with a trade-off, making it tough to decide.

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 sheets and data in Excel without losing any changes from a graphic tutorial.

Method 1. Recover Deleted Worksheet in Excel Before Saving

When you delete a sheet in Excel, there's no Undo option, but you can recover it by closing your workbook without saving changes and then reopening it. However, if you've made significant changes and don't want to lose them, you can try a different approach. To recover the deleted sheet, you can use the "File" menu to open the workbook in "Safe Mode" (hold the Shift key while opening the file). This will allow you to recover the deleted sheet without overwriting your existing changes. Alternatively, you can also try using the "File" menu to "Open a Copy" of the workbook, which will create a new copy of the file without the deleted sheet, allowing you to recover it without affecting the original file.

1. To save your current Excel document with a different filename, go to the "File" tab and click on "Save As". This will allow you to save your working document with a new name, while keeping the original file intact.

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 recover deleted worksheet data to the new renamed Excel document and preserve all changes made to the Excel.

Method 2. Recover Deleted Worksheet in Excel After Saving 

If you've saved your working Excel document, the original files will be overwritten and there's no way to restore the deleted worksheet. However, you can try to recover the original Excel document via the Previous Version.

1. To open the folder where the Excel document was saved, press the Windows key + E to open File Explorer, and then navigate to the folder where the document is located.

2. To view the files contained in the most recent backup of a folder, click on the Excel file, go to the "Home" tab on the toolbar, and then click the "History" button in the Open group. This will instruct File History to display all the files contained in the most recent backup of that folder.

3. To recover a deleted Excel worksheet, click the "Previous" button to locate and choose the version you want to restore, and then click the green "Restore" button to undelete the worksheet.

If you've accidentally deleted a sheet in Excel, you can recover it using the above methods. However, if you've deleted the entire Excel document instead of a single sheet, don't worry - you can still recover the file. To do this, you can try using Excel's built-in recovery feature, or you can also try using third-party software or online tools that specialize in recovering deleted files. In either case, act quickly, as the sooner you try to recover the file, the better your chances of success.

How to Recover Deleted Excel Files on Windows 10/11

Losing an Excel document can be frustrating, especially when it's due to unexpected deletion, hard drive formatting, device damage, or an OS crash. However, you don't have to give up hope. Deep Data Recovery can help you restore the lost Excel file, even if it's been permanently removed.

Step 1. Select file types and click "Next" to start

Launch Deep Data Recovery, select the desired file types, and click "Next" to initiate the recovery process.

Step 2. Select location and click "Scan"

Choose the drive or a specific folder on your Desktop or somewhere else where you lost the Excel files, and click the "Scan" button.

Step 3. Locate your excel files

To quickly find Excel files from the scan results, click on "Documents" in the left panel, select "Excel", and then click "Preview" to verify the files.

Step 4. Recover Excel files

Select the desired Excel files, click the "Recover" button, and choose a folder to save the recovered Excel files.

You can recover unsaved and deleted Word documents in Windows 10 by using the Windows File Recovery tool, which can retrieve files from a corrupted or damaged drive. Alternatively, you can try using the Word Document Recovery feature, which is built into Microsoft Word, or use a third-party data recovery software such as Deep Data Recovery Wizard.

Extra Guide: How to Recover Unsaved Excel Files

When working on a crucial Excel document, it's not uncommon for the power to suddenly go out, causing the file to disappear due to the computer shutting down without a chance to save it. This is a common scenario where Excel data recovery and restoring unsaved files become essential needs.

If you're worried about losing an unsaved Excel document with important data, take a deep breath and relax - Excel's AutoRecover feature has got you covered. You can recover unsaved Excel by following these simple steps.

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

2. After Excel crashes, you can restore your unsaved work by clicking on the "File" tab, then selecting "Recent" and clicking on "Recover Unsaved Workbooks". This will open a window showing all unsaved Excel files. Select the desired file and click "Open" to load the workbook.

3. To recover the worksheet, click the "Save As" button on the yellow bar.

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

To change the AutoRecover duration in Excel, open the program and click "File" > "Options". In the left navigation pane, click "Save", then change the AutoRecover duration in "Save AutoRecover information every xx minutes" and click "OK".

Even if you've enabled automatic saving, your computer will still keep temporary unsaved files for up to four days after the latest version. To ensure data security, it's a good idea to save your documents regularly and back up any saved files to an external hard drive if they're important.

• To recover lost or unsaved Excel files on a Mac, start by checking the Autosave feature, which may have saved a previous version of the file. If that doesn't work, try using the "Recover Unsaved Workbooks" feature in Excel.

Related Articles

• 5 Genius Ways to Fix Powerpoint Found a Problem with Content
• GIMP Recover Last Session: Recover Unsaved/Deleted/Lost GIMP Photos or Files
• How to Recover Deleted User Profile and Files in Windows 10/11
• ISO Recovery: Recover Deleted ISO Files with ISO Recovery Software

Is this information helpful?   Yes   No

This information is not relevant.

This information is not easy to understand.

This information is not deep enough.

What can we do to improve this information? (Optional)

Refresh Please enter the verification code!