How to Undo Changes in Excel After Saving and Closing in 4 Ways

If you're looking for information on how to undo changes and recover lost Excel files, you've come to the right place. Sometimes, we need to undo work that has been saved in a worksheet. There are several ways to undo a save. Here are four quick and easy methods to undo a save in Excel, even after closing the file.

Please provide the English content you want translated, and I'll translate it into Chinese for you as soon as possible.

We've all been there – working on an important Excel file and accidentally closing it without saving. Or, worse yet, experiencing a computer malfunction that causes us to lose all unsaved changes. Suddenly, it feels like all that work is gone forever. Fear not, though! It's usually possible to recover deleted Excel files.

If you have deleted the old version of Excel, or if your saved Excel is lost due to accidental deletion, hard drive formatting, or any other reasons, you can use utilities like Data Recovery Wizard Pro to help you recover deleted Excel from your computer or other storage devices in 3 simple steps.

Step one: Choose a location, and click “Scan.”

Select the disk partition where your lost Excel file was located, or choose a specific folder on Desktop or other locations, and then click on the “Scan” button.

Step 2: Locate your Excel file

To quickly locate Excel files from the scan results, click “Documents” on the left panel. Select “Excel,” and then click “Preview” to check if these Excel files are the ones you need.

Step 3: Recover the Excel File

Lastly, select the Excel files you need, and then click the “Recover” button. After that, choose a folder to save these Excel files to another location.

How to Undo Changes in Excel After Saving and Closing If you accidentally saved an Excel workbook and closed it, but later realize you need to undo some changes, don't worry. Here are a few methods that might help you recover your original data: ### Use AutoSave or Version History (Microsoft 365/OneDrive) 1. Open Excel and click on "File" in the top-left corner. 2. Select the "Info" tab. 3. If you're using a file synced with Microsoft 365 or OneDrive, you may see "Manage Versions." Click on it. 4. In the popup window, browse and select an earlier version to restore. 5. Click "Restore" to replace the current version. ### Use Backup or Work Copy 1. Check your computer's backup folders, like "My Documents" or "Desktop," for automatically saved copies before you saved the changes. 2. If you have a work copy, simply open that file. ### Recover from Trash 1. If you deleted the file by mistake, check your computer's Recycle Bin or Trash. 2. Find the unchanged Excel file, right-click it, and choose "Restore." ### Use Data Recovery Software If none of the above methods work, you might need to use professional data recovery software to attempt retrieving the original file. Note that this is not guaranteed and may involve additional costs. ### Preventive Measures To avoid such issues, ensure that AutoSave is enabled in Excel and regularly back up your workbooks to a secure location. This way, if you accidentally save incorrect changes, you can easily retrieve previous versions.

If you've made changes to a worksheet and wish to revert to the original data, you might need to undo all the changes. To undo changes, you can use Excel's Undo feature. However, clicking the Undo button repeatedly can be time-consuming if you want to undo multiple alterations to a worksheet. After modifying a spreadsheet, there are methods to recover unsaved Excel files. Visit that section for more information.

Fix 1: Tap the Undo button.

If you haven't closed the workbook, you can easily undo the Save action in Excel by using the Undo button on the Home tab.

To undo changes to the active worksheet, click the Undo button on the Quick Access Toolbar.

1. Click the "?" button next to the Undo button to display a list of all changes made to the worksheet. Move your pointer over the most recent change, click to select all the changes in the list, then click it to undo them all at once.
2. This list also includes any changes made to other worksheets within the current workbook. As such, using this method to undo all changes on a specific worksheet can become difficult.

Now you know three ways to undo changes in Excel after closing and saving. Before you go, hit the share button on Facebook, Twitter, or your favorite social network to bookmark this tutorial.

Fix 2: Use the keyboard shortcut Ctrl+Z to undo Excel actions

If the document is still open, you can quickly undo any changes by clicking the “Undo” button in the Quick Access Toolbar or pressing Ctrl+Z. Then, save the document again.

The standard keyboard shortcut to undo an action is Ctrl+Z. In Excel, if the worksheet hasn't been closed, you can use the shortcut Ctrl+Z to undo a save. This will revert to the previous values and undo the saved changes.

Please provide the English content you want translated, and I'll translate it into Chinese for you as soon as possible.

How to Recover Ctrl+Z Files: Ctrl+Z Deleted My File

Accidentally pressed Ctrl + Z and lost your file? Don't worry. This guide will explain 2 ways to recover files deleted by Ctrl + Z. Read More>>

Fix 3: Use Version History to Undo Save

In Excel, you can revert to a previous version of a workbook as another way to undo a save. You can do this by using the Version History option.

OneDrive is an excellent choice for storing Excel files. You can purchase more storage as needed, and it comes with 2 GB of free space. It also keeps previous versions of your files, so you can recover earlier versions if necessary. The following will show you how to retrieve unsaved Excel data from OneDrive.

Step 1: Go to the OneDrive website and sign in with your account information.

Step 2: Click on the “Documents” folder where you saved your file.

Step 3: Find the Excel file you need, and right-click it.

Step 4: Click “Version history.” This pane on the left shows you every previous version of the file.

Step 5: Once you've found the version you need, click “Download” to download a copy, or click “Restore” to replace the current version.

Solution 4: Restore Excel Changes from a Backup

Another way to quickly restore original data after modifying an Excel worksheet is to back up the sheet first. You can easily back up a worksheet with the following VBA code:

Step 1. Keep the original data in the worksheet and press Alt + F11 to open the Microsoft Visual Basic Application window.

2. In the Microsoft Visual Basic application window, click Insert > Module, and then copy and paste the following VBA code into the module window.

Step 3: Press F5 to run the code, and a new backup worksheet is created that's an exact copy of the original.

How to Restore a Previous Version of an Excel File After Saving

If you haven't already undone the changes and saved the file, you might be able to get an earlier version of the Excel file with one of these methods. If AutoRecover is turned on, Windows can automatically save versions of the file while you're editing it. Follow the instructions in this article to recover an unsaved earlier version of Excel.

Step 1: Click File > Info > Manage Workbooks > Recover Unsaved Workbooks.

Step 2. Select your file and click “Open.”

Step 3: To save the file, click “Save As” in the top bar of the document.

In sum

This article shows you the four easiest ways to undo save in Excel. Any of these methods will do the job. I sincerely hope you enjoy and learn something from this article. If anything is unclear, please leave a comment. Let us know if you're aware of any other options we might have missed. For more file recovery needs, try the tool Data Recovery Wizard.

Q&A: How to Reverse Changes After Saving and Closing Excel

Here are 4 additional questions about how to undo changes after closing Excel without saving. You can check the answers here.

**1. How do I undo all changes to restore the original data in Excel?** To undo all changes and restore the original data in Excel, you can use the "Undo" feature. Follow these steps: 1. Open the Excel workbook with your modifications. 2. Click on the "Edit" option in the menu bar (in older versions, it might be under the "Tools" menu). 3. From the dropdown menu, select "Undo" or press the keyboard shortcut `Ctrl+Z`. This will revert the most recent action. 4. Repeat this process as many times as necessary to undo all changes until you return to the original state. Please note that Excel can only undo a certain number of steps (by default, 100 steps). If you've exceeded this limit, earlier modifications may be irrecoverable. In such cases, you might need to restore the original data from a backup file.

• Use the “Undo” button and keyboard shortcuts to undo all changes and revert to the original data. • Restore any modifications made to the original data from a backup. • Utilize the “Data Recovery Wizard” tool to undo all changes and restore the original data.

2. Can I recover an Excel file that I accidentally overwrote?

You can try to recover the overwritten Excel file by using the "Previous Versions" feature on Windows 10. After enabling File History or Windows Backup on Windows 10 or 11, you can recover an overwritten Excel file by following this guide: Recover Overwritten or Replaced Excel and Word Documents.

**3. How to Undo Changes in Excel After Saving?**

If the document is still open, you can quickly undo all changes by clicking the “Undo” button in the Quick Access Toolbar or pressing Ctrl+Z on your keyboard. Then, save the document again.

4. How can I undo changes after saving a file?

In any version of Word, if you have been using Undo a lot, you may be able to get back to where you started – assuming that you were editing a document that you intended to “Save As” rather than simply “Save,” and that you haven't closed the file.

Therefore, if the document is still open, you can use the Save As command from the File menu to save it under another name, and then use the Undo command to back out of the changes and save the document under its original name.