Learn how to recover deleted sheet in Excel with two methods on this page. And get tips for the lost/unsaved/corrupted Excel files and data loss prevention.
I have an Excel file with 15 sheets. But I accidentally 3 sheets in Excel and remain 12 sheets are there. So is there any way to recover deleted sheet in Excel? Thanks.
-A user from SpiceWorks
Generally speaking, an Excel file usually contains several sheets for different items. So are you wondering how to recover deleted sheet in Excel? Don’t be concerned because you can find answers in the following content.
You can select a targeted solution to recover the accidentally/permanently deleted sheet in Excel. Please pay attention to the corresponding premise for each method.
What can you do to recover the accidentally deleted sheet in Excel? If you’ve enabled AutoSave, you can recover it using it because this feature could automatically save your editing Excel files at default or customized time intervals.
Step 1. Open your Excel program, then click “File” and select the “Info” option.
Step 2. All the recently auto-saved Excel files are listed in the Manage Versions section.
If the above solution cannot help you, it turns out there’s a better way to recover deleted sheet in Excel after save. That is restoring previous versions of Excel files.
These steps describe how to recover deleted sheet in Excel after save. And it also applies to recovering overwritten Excel files in Windows.
Step 1. Open Windows File Explorer by pressing the “Win + E” keys.
Step 2. Find the folder that includes your needed Excel files. Then right-click on your located folder and select the “Properties” option.
Step 3. Select an Excel file version after browsing all the listed versions. Remember to save your chosen Excel file to your destination saved path.
There’s no better way than utilizing professional data recovery to recover deleted/lost Excel files. MyRecover is such a well-received tool. And it is prepared to recover the deleted/lost files from HDD, USB, SD card, and other storage devices. Let’s tap into its key features.
Step 1. Download and install MyRecover on your PC.
Step 2. After loading the disk, hover the mouse over the partition including the Excel files you want to restore. Then click Scan.
Step 3. Search or wait to view all the deleted and other missing files.
Step 4. Go to the Deleted files/Other missing files folder, and click “Recover x files” to get your selected Excel files back. Please save them in a new location.
This post shows how to recover deleted sheet in Excel with two solutions. If you need, please consider using data recovery tools like MyRecover to recover deleted/lost Excel files. And there’re other tips for the unsaved/corrupted Excel files.
With AutoRecover, you can perform the unsaved excel file recovery Windows 10 Start your Excel files, then click File > Info > Manage Workbook > Recover Unsaved Workbooks. After that, you can restore your selected Excel file among all the unsaved Excel files.
You can use the built-in feature to recover corrupted Excel files in WIndows. Locate the folder containing your needed corrupted Excel files and Open this corrupted file. Then select the Open and Repair option. You can click Repair to recover the corrupted data as much as possible or click Extract Data to extract vital formulas.
Enable AutoSave and AutoRecover. Open your Excel files, then click File > Options > Advanced > Save. And tick Always create a backup copy > OK. The backup copy cannot help you recover deleted sheet in Excel because it will also save your changes automatically. But the backup copy can help you recover deleted/lost Excel files if you only deleted the original Excel files. Use Windows features like Previous Versions to make files/folders backup regularly. In this case, utilize free backup software for Windows, AOMEI Backupper to make a “File Backup”.