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

Get FREE Advanced Excel Exercises with Solutions!

If you are finding ways how to undo a save in Excel, this is the right place for you. Sometimes, we save work and then need to undo that in the worksheet. We can undo the save in several ways. Here, you will find 5 easy and step-by-step ways to undo a save in excel.

Download Practice Workbook


4 Ways to Undo a Save in Excel

Here, we have the following dataset containing the list of sports of some students. We will change some data in the dataset and save the changes. Then, we will show you how to undo the save in excel and get the previous dataset.

Dataset to Undo a Save in Excel


1. Using Undo Button to Undo a Save in Excel

If you haven’t closed the sheet, you can undo a save in excel simply by using the undo button from the Home ribbon. From the dataset given below, I will change some cell values to Save it and Undo it.

Steps:

  • First, select cell C6 and change its value.
  • We replaced the value ‘Basketball’ and inserted ‘Swimming’.
  • Now, press CTRL+S to Save to changes.

Using Undo Button to Undo a Save in Excel

  • Then, select the Home ribbon.
  • From there, click on the Undo button.

  • Finally, the save will be undone. The value of Cell C6 again will change into ‘Basketball’.

Using Undo Button Undo a Save

Read More: How to Undo Changes in Excel after Save and Close (2 Easy Methods)


2. Use of Keyboard Shortcut Ctrl+Z to Undo a Save

Generally, the keyboard shortcut Ctrl+Z is used to undo the previous action. If you haven’t closed the sheet, you can also undo a save by using the keyboard shortcut Ctrl+Z in Excel. This will undo the saved item and retrieve the previous value.

Steps:

  • First, select cell C6 and change its value.
  • We replaced the value ‘Basketball’ and inserted ‘Swimming’.
  • Now, press CTRL+S to Save to changes.

Using Keyboard Shortcut Ctrl+Z to undo a save in Excel

  • Then, press the keyboard shortcut Ctrl+Z.

  • Finally, the value of cell C6 will change to its previous value ‘Basketball’.

Using Keyboard Shortcut Ctrl+Z to Undo a Save in Excel

Read More: How to Undo Remove Duplicates in Excel (3 Ways)


Similar Readings


3. Using Manage Workbook Feature to Retrieve Earlier Versions of Excel File 

Workbook Manager Feature creates a database of all open Excel workbooks so you may easily navigate through them. You can insert, rename, delete, resort, and retrieve workbooks using this feature.

Steps:

  • First, change the Cell C6 value ‘Basketball’ as ‘Swimming’ and Save the data by using the shortcut CTRL+S.

Using Manage Workbook Feature to Undo a Save in Excel

  • Then, click on File to open the File section.

  • After that, from Info >> go to Manage Workbook >> then select autorecovery workbook.

Using Manage Workbook Feature Undo a Save in Excel

  • Finally, the value of cell C6 changed to its previous value ‘Basketball’.

Using Manage Workbook Feature Undo a Save in Excel

Read More: How to Undo and Redo in Excel (2 Suitable Ways)


4. Employing Version History Option to Undo a Save

You can also undo a save in Excel by retrieving the previous version of the workbook. For this, you have to use the version history option.

Steps:

  • First, in the dataset, we added the Age of the students in column D.

Using Version History Feature Undo a Save in Excel

  • Then, we changed all the data from Cell D5 to Cell D11 and saved the values by using CTRL+S.

  • After that, click on File to open the file section.

Using Version Huistory Feature Undo a Save in Excel

  • Then, click on Info >> select Version History.

  • Next, the Version History list showed up.
  • From there, you can select the desired version to open in a separate window by clicking on the Open version.
  • Here, I selected the version of my choice.

Using Version History Feature Undo a Save in Excel

  • Next, click on Restore to retrieve the previous version in Excel.

  • Finally, all the data from Cell D5 to Cell D11 is restored.

Using Version History Feature Undo a Save in Excel

Read More: [Fixed!] Undo and Redo in Excel Not Working (3 Simple Solutions)


Conclusion

So, in this article, we have shown you the 4 easiest ways how to undo a save in Excel. You can use any of these methods to get the job done. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Please let us know if there are any more alternatives that we may have missed. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo