Recover deleted Sheet in Excel

When you delete Sheet in Excel, it seems that the Undo keyboard shortcut has no effect. So how to recover deleted Sheet in Excel?

1. How to delete Excel Sheet?

To delete Sheet in Excel, you just need to right-click on the Sheet and select Delete.

Picture 1 of Recover deleted Sheet in Excel

2. Recover deleted Sheet with Ctrl + Z / Undo

For this method, not 100% of Excel files will be successful, but if you don't try it, how do you know correctly?

Operation: After deleting the Sheet, you select the Undo shortcut icon or press Ctrl + Z to let the deleted Sheet return.

Picture 2 of Recover deleted Sheet in Excel

3. Cancel saving the Excel file to restore Sheet

When you delete the wrong Sheet in Excel, the first thing you need to do is to be calm to handle the work. Unsaved the file will prevent Excel from overwriting your file and keep everything as it was when you opened the file.

Operation: You select the X icon to exit the application, Excel will ask you if you want to save it or not? Please choose Don't Save to keep everything as original.

Note: If you have edited an Excel file a lot and want to keep the edited content, you should create a new Excel file and copy the data before exiting the application.

After exiting the Excel software, you can reopen the Excel file.

Picture 3 of Recover deleted Sheet in Excel

4. Find an earlier backup of Excel

In the process of using the software, Excel continuously creates different backups so that you can restore when needed.

Step 1: First, you choose File -> Option to enter the settings.

Picture 4 of Recover deleted Sheet in Excel

Step 2: After that, you select Save (1) and Copy the link in AutoRecover file location (2).

Picture 5 of Recover deleted Sheet in Excel

Step 3: Next, go back to the File section and choose Open -> Recent -> Recover Unsaved Workbooks.

Picture 6 of Recover deleted Sheet in Excel

Step 4: At this point, please highlight all the links and right click and choose Paste to paste the link we just copied earlier.

Picture 7 of Recover deleted Sheet in Excel

Step 5: Now you just need to find the AutoSave file of Excel is finished, normally the AutoSave file usually has (Version…).

Picture 8 of Recover deleted Sheet in Excel

In addition, you can also search by the Document Recovery window after opening the AutoSave file.

Picture 9 of Recover deleted Sheet in Excel

In this article, TipsMake instructed you how to recover deleted Sheet in Excel. Good luck!

Update 07 October 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile