How to Undo Changes in Excel after Save and Close (2 Easy 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 NameDepartment, and Salary titled data.

How to Undo Changes in Excel after Save and Close


Download Practice Workbook


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

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, then regret on it thinking about the previous versions. It is quite amazing that we can undo changes even after Save and Close.  We can use the Info feature in the File tab to do so. Excel allows you to do mistake  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 Save and Close.

Read More: How to Undo a Save in Excel (4 Quick Methods)


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 Save and Close.

How to Undo Changes in Excel after Save and Close

Read More: How to Save a Worksheet as a New File Using Excel VBA


Practice Section

For expertise, you can practice here.


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

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo