How to Undo Changes in Excel after Save and Close (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

It is not impossible that we might be in need of restoring the previous version of our worksheet after saving and closing it. For that, We have to undo changes in Excel after Save and Close.

In order to clarify the topic, I used a Dataset along with Employee Name, Department, and Salary data.

How to Undo Changes in Excel after Save and Close


How to Undo Changes in Excel after Save and Close: 2 Easy Methods

1. Using Version History to Undo Changes after Save and Close

To err is human. It is not an unforgivable mistake to edit an Excel file, Save and Close it, and then regret it thinking about the previous versions. It is quite amazing that we can undo changes after saving and closing.  We can use the Info feature in the File tab to do so. Excel allows you to make mistakes but the condition is to have the AutoSave option turned on.

Steps:

  • First, go to File.

  • Next, select Info.
  • Choose Version History from there.

How to Undo Changes in Excel after Save and Close

  • Now, Choose your required modified version.

  • Click on the Restore button.

How to Undo Changes in Excel after Save and Close

  • Finally, the file will be restored even after saving and closing.

Read more: How to Recover Previous Version of Excel File


2. Use of Manage Workbook to Undo Changes after Save and Close

Manage Workbook in Info Feature is also another option to undo changes after Save and Close.

Steps:

  • Go to File.

  • Then, choose Info.
  • Next, click on the version of a file you want to restore beside the Manage Workbook.

How to Undo Changes in Excel after Save and Close

  • Click on Restore.

Then, the file will be like the undo changes even after saving and closing.

How to Undo Changes in Excel after Save and Close


Practice Section

For expertise, you can practice here.


Download Practice Workbook


Conclusion

I have explained how to undo changes in Excel after Save and Close as simply as possible. I hope it will be helpful for Excel users. For any more questions, comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Naimul Hasan Arif
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

2 Comments
  1. Thank you, This information was helpful.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo