In this lesson, I’ll demonstrate the necessary approaches on how to undo a delete sheet in Excel. Moreover, these techniques will enable you to solve the problem that led you here. However, you will master several crucial Excel features during this article, which will come in extremely handy for any assignment using Excel.
📁 Download Excel File
The sample worksheet that was used during the discussion is available to download for free right here.
Learn to Undo Delete Sheet in Excel with These 2 Useful Techniques
Here in this article, we will learn how to undo a delete sheet in Excel. After we delete a sheet in Excel it is deleted permanently as you will see in a dialogue box while deleting any sheets. I’ve provided a method with detailed instructions down below which will be only applicable if you have a saved Excel file and are working on it.
1. Make a Copy to Undo
Let’s say you have accidentally deleted a worksheet from your Excel File. It is hard to recover deleted worksheets. Note that this method is applicable only if you have not already closed that exact Excel file. Follow the instructions below.
⬇️⬇️ STEPS ⬇️⬇️
- Let’s say we have these 3 worksheets in our Excel file.
- Now let’s say we have modified the file and before saving we accidentally deleted a worksheet. For instance, here we are assuming it to be the Sample In the picture below we can no longer see the Sample worksheet and we can clearly see that we modified the cells here.
- Now we have to recover the workbook. So now we will save the file as a new copy, for that go to Files Tab from the ribbon and then select Browse from the Save as.
- Now type in a different name for creating another file. Here I’ve only added _new to the original file name as it will be easier to find.
- Now Open both Excel files together. As you can see here one file here has all the worksheets and another one has one less worksheet but is modified.
- Now go to the Book1 or the original file that has all the worksheets and copy the deleted worksheet by right-clicking on the sheet name and clicking the Move or Copy…
- After that, you will see a Box appearing. Do as this sequence check the Create a copy option.
- Then Click the dropdown from To book
- After that Select your new Excel file and Click OK.
- Now as you can see we have successfully recovered the worksheet while having the modifications.
2. Restoring from Recycle Bin
Say you have deleted your Excel file and now you want to restore it (this includes all of the sheets that got deleted). You can do it by following these steps.
⬇️⬇️ STEPS ⬇️⬇️
- First, go to the Recycle Bin from Desktop or from the Windows option where you will see your deleted files.
- Right Click on the file and click on Restore and you are done.
📄 Important Notes
🖊️ Be careful while deleting any sheets in Excel if you are working on a Blank Workspace.
🖊️ Restoring sheets is very difficult.
🖊️ Use the Autosave Feature of Excel.
🖊️ Always Save after any big operation.
📝 Takeaways from This Article
📌 How to undo delete sheet in excel.
📌 Don’t forget to save your file.
📌 Transferring sheets from one file to another.
📌 How to restore deleted Excel Files.
Firstly, I hope you were able to use the techniques I demonstrated in this “How to undo delete sheet in Excel” lesson. As you can see, there are a lot of options on how to do this. However, decide deliberately on the approach that best addresses your circumstance. Most importantly I advise repeating the steps if you become confused in any of the steps if you get stuck. Practice on your own after taking a look at the Excel file in the practice workbook I’ve provided above because practice makes a man perfect. Above all, I earnestly hope you can use it. Please share your experience with us in the comment box about how your experience was throughout the article and what we need to improve or add to make things better for you folks. However, if you have any problem regarding Excel spit it in the comment box. The Excelden crew is always available to answer your questions. In conclusion, keep educating yourself by reading. For more Excel-related articles please visit our website Excelden.com.