How to Undo Delete Sheet in Excel (3 Methods)

Sometimes you might accidentally delete the worksheet or even the whole workbook you are working on. This could be a disaster if you are working with important data and have no backup copy of that Excel workbook. In this article, I will show you how to undo delete sheet in Excel.


Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.


3 Easy Ways to Undo Delete Sheet in Excel

Let’s assume a scenario where we have an Excel file that contains information about the Annual Salary and Tax Rate of the employees of a company. I will use this Excel workbook to show you how to undo delete sheet in Excel.


Method 1: Make a Copy of the Existing Sheet to Undo Delete Sheet in Excel

If you accidentally have deleted one or multiple worksheets of your Excel workbook but have not saved the file afterward, you can still recover the deleted worksheet. The easiest way is to close the workbook without saving it. But if we do that, the changes we have made will not be saved. If you want to undo the deleted sheet while keeping the changes you have made, you can do so by making a copy of the workbook. Let’s see how we can do that.

Step 1:

  • First, we will click on the File.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • Next, we will click on the Save As Command.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • Then, we will save the existing workbook with another name.
  • Finally, we will click on OK.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • Now, we will click on the Close button to close the existing workbook.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

Step 2:

  • We will now open the new workbook that we have saved with a new name.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • We will see that all the changes are saved in the worksheet. But the workbook does not have the deleted worksheet.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • We will now open the old workbook.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • We will see that changes we have made after the deletion are not saved but the workbook has the deleted worksheet in it.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

Step 3:

  • We will now move the worksheet that was accidentally deleted from the old workbook to the new workbook.
  • To do that, we will right-click on the name of the sheet from the sheet tab. A menu will appear. We will click on the Move or Copy from that menu.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • We will now select the name of the new workbook from the To book drop-down.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • Then, we will select the move to end option from the Before sheet
  • Next, we will check the option Create a copy.
  • Finally, we will click on OK.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

  • Now, the accidentally deleted worksheet will move to the new worksheet while the changes we have made also be saved.

Make a Copy of the Existing Worksheet to Undo Deleted Sheet

Read More: How to Undo and Redo in Excel (2 Suitable Ways)


Similar Readings


Method 2: Recover Delete Sheet Using the AutoSave Feature in Excel

We might accidentally close a workbook without saving the changes or there was a technical glitch that forced Excel to close abruptly without letting you save the change or the new worksheets you added in that workbook. In such a case,  you can recover the workbook using the AutoSave feature of Excel. We have to follow the below steps.

Step 1:

  • First, you have to open the abruptly closed Excel workbook. Upon opening the file again, you will see a pan titled Document Recovery on the left side of the workbook. It will tell us that it has recovered the file that was closed unexpectedly.

Recover an Unsaved Workbook Using the AutoSave Feature

Step 2:

  • We will click on the drop-down like below and select Save As from the menu to save the recovered file.

Recover an Unsaved Workbook Using the AutoSave Feature

  • Alternatively, we can also save the file using the Manage Workbook First, We will click on the File tab.

Recover an Unsaved Workbook Using the AutoSave Feature

  • Then, we will click on the Info.

Recover an Unsaved Workbook Using the AutoSave Feature

  • Now, we will see the workbook we have accidentally closed under the Manage Workbook We will click on it.

Recover an Unsaved Workbook Using the AutoSave Feature

  • We will now see the workbook we are trying to recover. We will see a message titled RECOVERED UNSAVED FILE that says, This is a recovered file that is temporarily stored on your computer.

Recover an Unsaved Workbook Using the AutoSave Feature

  • Finally, we will save the recovered file using Save As option.

  • We can also right-click on the name of the file and select Restore previous versions from the menu to restore the file.

Recover an Unsaved Workbook Using the AutoSave Feature

Read More: Shortcut to Delete Sheet in Excel (5 Quick Examples)


Method 3: Undo Delete Sheet from the Recycle Bin in Excel

Instead of deleting the Excel workbook permanently if we just delete the file temporarily, we can recover the file from the Recycle Bin. We have to do the following.

Steps:

  • We will go to the Recycle Bin and find out the deleted Excel workbook.

Recover a Deleted Workbook From the Recycle Bin

  • We will then right-click on the name of the workbook. A menu will appear. We will click on the Restore option to restore the file.

Recover Recover a Deleted Workbook From the Recycle Binan Unsaved Workbook Using the AutoSave Feature

Read More: Excel VBA: Delete Sheet If It Exists (4 Methods)


Quick Notes

🎯 Always backup your important Excel workbook in another drive of your computer or a cloud file backup system like Google Drive or OneDrive. If you accidentally delete a workbook or worksheet you can always recover them using the backup.

🎯 If you permanently deleted a file, you can recover them using a trusted and reliable data recovery software.


Conclusion

In this article, we have learned how to undo deleted sheet in Excel. I hope from now on you can undo delete sheet in Excel very easily. However, if you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!!


Related Articles

ASM Arman

ASM Arman

Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo