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

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


<< Go Back to Recover Excel File | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo