Is it possible to restore a deleted worksheet? Have you ever wondered whether it’s possible or not to recover a deleted Excel worksheet. The job may look scary, but don’t be scared because there’s a way of recovering a delete Excel sheet. Let me take you through the process of fixing this sad situation. When you mistakenly delete a calculator tab containing important information, you have two options. The first option is to shut down an Excel file without saving, which allows you to restore the delete worksheet value.Clicking Save makes deletion permanent. Both solutions have drawbacks, making it difficult to choose.
Not to worry. Here to help. You may recover Excel 2007-2016 spreadsheets and data without losing modifications. I will provide visual help to make the process clearer.
We will begin by talking about how to recover deleted worksheets in Excel 2007/2010/2013/2016
Method 1: Restore deleted worksheets in Excel before saving.
Unfortunately, Excel does not provide you with a cancellation feature for deleting worksheets, which is very disappointing. However, there is a ransom. If you close and reopen your workbook without saving it, you can load deleted files. In order to get the removed worksheet. To keep any changes made to your worksheet while guaranteeing recovery, follow these steps:
Save your running Excel document by clicking “Save as” in the “Files” tab.
Open the Excel document again
Copy the deleted sheet from the original file and place it in a new document with a different name.
By following these steps, you can find the deleted worksheet information and store all the changes you have made in the renamed Excel document.
Method 2: Restore deleted worksheets in Excel after saving
This method writes the original file, therefore recovering erased worksheets is difficult. Still, there is hope. Use “Previous Version” to return to the original Excel file. What to do:
- Open Explorer with Windows + E and find the Excel file’s folder.
- Select the Excel file and select “Home” from the menu. In the “Open” group, click “History”. This shows the folder’s latest backup file in file history.
- To find the version you want to recover, click the “Previous” button and select it. If you do not want to delete your current Excel file, click on the green “Restore” button.
Follow these instructions to recover deleted Excel sheets using both approaches. Don’t worry if you mistakenly delete all your Excel files instead of using certain worksheets. Read on to locate them easily.
How to Recover Deleted Excel Files on Windows 10/11
Moving on to Windows 10/11 Excel file recovery. WinfrGUI, the free file recovery software can restore deleted Excel files at all times, even if they were deleted, formatted, or damaged.
Follow these steps to recover deleted Excel files with WinfrGUI:
Step 1: Select the location where the Excel file is lost and click on “Scan”.
Step 2: In the left panel, click “Documents” to find an Excel file in the scan results. Select “Excel” and click “Preview” to confirm that you have selected the correct file.
Step 3: After selecting an Excel file, click on “Recover”. Select the folder to save the recovered Excel file.
Extra Guide: How to Recover Unsaved Excel Files
In addition to recovering deleted Excel files, I will give you instructions on how to restore unsaved Excel file. It often happens that while working with important Excel documents, there is a sudden power outage and you have no chance to click on the save button. Don’t worry. Excel has AutoRecover feature which can help you get unsavaged Excel files.
To recover unsaved Excel files, follow these steps:
- Open Excel and click the “Files” tab.
- From the “Information” section, select “Manage workbooks” and then select “Recover unsaved worksbooks” from the menu.
- An unsaved Excel file window will appear. Select the file you want to recover and click “Open” to load the workbook.
- To restore the sheet, click the “Save as” button on the yellow bar.
Please note that this solution works if the AutoRecover feature is enabled. If not enabled, you can follow these steps to enable it:
- Open Excel
- Click “Files” and select “Options” in the left navigation bar.
- Click on “Record”
- Set the AutoRecover interval in the “AutoRecover Saves Every xx Minutes” field and click on “OK”.
Even if AutoRecover is enabled, your computer will temporarily store unsaved files for up to four days. To ensure that your information is secure, it is recommended that you regularly save your documents and back up important files to an external hard drive.
