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

Let’s use a sample dataset that contains columns for Employee Name, Department, and Salary data. We’ll make some changes and undo them after you’ve saved the file.

How to Undo Changes in Excel after Save and Close


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

Method 1 – Using Version History to Undo Changes after Save and Close

Steps:

  • Go to File.

  • Select Info.
  • Choose Version History.

How to Undo Changes in Excel after Save and Close

  • Choose your required modified version.

  • Click on the Restore button.

How to Undo Changes in Excel after Save and Close

  • The file will be restored even after saving and closing.

Read more: How to Recover Previous Version of Excel File


Method 2 – Use Manage Workbook to Undo Changes after Save and Close

Steps:

  • Go to File.

  • Choose Info.
  • Click on the version of a file you want to restore next to Manage Workbook.

How to Undo Changes in Excel after Save and Close

  • Click on Restore.

  • That version of the file will open, and you can save it as the current version.

How to Undo Changes in Excel after Save and Close


Practice Section

Use the practice workbook to make changes and undo them.


Download Practice Workbook


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