Undo Changes in Excel After Saving: Your Recovery Options

How-to basics · Updated November 20, 2026

If the workbook is still open, press Ctrl+Z on Windows (Command+Z on Mac) to undo saved edits; saving usually does not clear Excel’s Undo history. If you have closed and reopened the file, use Version History for a workbook stored in OneDrive or SharePoint, or look for a backup or Windows previous version. First identify where the file is stored and, before restoring anything, make a copy of its current state.

What You’ll Need

  • The Excel workbook and access to the computer or account where it is stored.
  • For Version History, an internet connection and permission to access the OneDrive or SharePoint file. The feature works only when the workbook is stored in a supported cloud location and versions are available.
  • For local recovery, a backup or a Windows File History or restore-point setup that captured an earlier version. These options are not automatically available on every PC.

Step-by-Step

  1. If the workbook is still open, undo the edits. Click inside the workbook and press Ctrl+Z on Windows. On a Mac, press Command+Z. You can also select the Undo arrow on the Quick Access Toolbar. Repeat the shortcut one action at a time, checking the sheet after each undo so you stop at the right point. Excel normally keeps the undo stack after you save, as long as the workbook has stayed open and the actions can be undone. Saving itself is not undone; the shortcut reverses earlier edits.

    If you undo too far, press Ctrl+Y on Windows or Command+Y on Mac to redo an action. The Redo button may also be available on the Quick Access Toolbar. Once the sheet looks right, save it with Ctrl+S or Command+S. If Excel has already closed, or the undo arrow is unavailable, continue with the version or backup options below.

  2. Check Version History for a cloud workbook. In Excel for Microsoft 365 on Windows, open the workbook and select File > Info > Version History. Depending on the Excel build, you may also be able to select the workbook name in the title bar and choose Version History. In Excel for Mac, look under File > Browse Version History. In Excel for the web, select the workbook name and look for Version history. The wording or location can vary slightly by app version.

    Choose a version dated before the unwanted edits. Open it and confirm that it contains the data you need; do not assume the newest listed version is the correct one. If the version is right and you want to make it the current workbook, select the restore option shown in the version-history view and confirm. Excel may create a new current version from the restored contents rather than erase the history. The exact controls can vary between desktop, web, and organization accounts.

    Before restoring, use File > Save As to save a separate copy of the current workbook, or download a copy from the cloud. This gives you a way back if the older version is missing newer work you still need. If you cannot restore because you have read-only access, ask the file owner or a SharePoint administrator for permission.

  3. Copy only the needed content from an earlier version. Restoring replaces the current workbook contents, so it may be safer to open the earlier version and copy just the affected cells, sheet, or range. Compare the two versions first, then copy and paste into the current workbook. For formulas, check whether their cell references still point to the intended places after pasting. For a whole worksheet, use the sheet tab’s move-or-copy command and select the current workbook as the destination, if both workbooks are open. Save a separate copy before making substantial changes.

  4. Look for a Windows previous version if the file is local. Close the workbook, then open File Explorer and browse to the workbook’s folder. Right-click the workbook and choose Properties > Previous Versions. If a suitable dated copy appears, select it and use Open to inspect it before choosing Restore. To avoid replacing the current file, copy the previous version to another folder instead, if that option is available. This tab may be empty if File History, a backup, or another version-capture feature was not enabled or did not save a copy.

  5. Check the backup service or backup location. If the file is in a synced OneDrive or SharePoint folder, use the service’s version history for that file, even if you usually open it in desktop Excel. For another cloud provider, check its file activity or version-history controls. If your organization uses a backup system, ask its support team whether a snapshot exists from before the changes. For a manually maintained file, search for copies with dates or labels such as backup in the name, and open a copy rather than overwriting the current workbook.

  6. If no earlier version exists, preserve what remains and rebuild carefully. Save a copy of the current workbook first. Check emails, shared folders, exported PDFs, or reports for the missing values, then re-enter only what you can verify. Excel’s AutoRecover is intended mainly to help recover unsaved work after a crash; it is not a dependable history of edits already saved to a file. You can check File > Info > Manage Workbook for available recovery files, but do not expect it to contain the state from before a saved edit.

Common Mistakes

  • Closing Excel before trying Undo. The Undo stack is not a permanent change log. After closing and reopening a workbook, you generally cannot use Ctrl+Z to reverse the session’s earlier edits.
  • Restoring without keeping the current copy. An older version may also remove valid edits made since that version. Save a separate copy before you restore or replace anything.
  • Assuming every saved workbook has Version History. A file saved only to a local drive does not automatically get Microsoft 365 cloud version history. A cloud file can also have limited versions or access restrictions.
  • Confusing AutoRecover with version history. AutoRecover may help after a crash or when recovering an unsaved workbook, but it is not a reliable way to roll back a file that was saved and closed.
  • Restoring the wrong copy. A workbook may have similarly named copies in Downloads, a shared folder, and OneDrive. Check the path, date, and contents before replacing the file you normally use.

Tips

  • For important workbooks, keep the file in OneDrive or SharePoint so you can use cloud version history, subject to your organization’s settings and retention policies.
  • Make dated copies before large edits, imports, or structural changes. Use a clear name and store the copy somewhere separate from the file being edited.
  • When recovering only a few cells, compare the old and current versions before copying. Check formulas, formatting, named ranges, and any dependent charts or tables.
  • For a shared workbook, tell collaborators before restoring a version. Ask them to save their own current work so their edits are not unexpectedly replaced.
  • After recovery, save the repaired workbook and reopen it to confirm that the right file was changed. Keep the safety copy until you have verified the restored data.

Troubleshooting

Version History is missing. Confirm that the workbook is stored in OneDrive or SharePoint, not merely in a local folder or an unsynced copy. Sign in to the account that owns or can edit the file, then reopen it. If it is a work or school account, the organization may restrict version history or retention; ask the file owner or administrator.

No older version is listed. The file may not have been saved to the cloud before the unwanted changes, or older versions may have expired under the service’s retention settings. Check whether you opened the right account and file. Then look for a local backup, a Windows Previous Versions entry, or an organization backup. If none exists, Excel may not have a recoverable pre-edit copy.

Undo is greyed out or skips the change. Some actions cannot be undone, and certain operations or add-ins can clear the undo history. If the workbook was closed, the history is normally gone. Use Version History or a backup instead. If Undo is available but reverses too much, use Redo immediately and consider recovering a dated version or copying back only the affected cells.

The restored workbook still has the wrong data. Check the version date and inspect the sheet that contains the change; a timestamp alone does not tell you exactly what was edited. If you restored the wrong version, open Version History again and select the correct one, or use your safety copy. For a local previous version, copy the needed file to a separate location before trying another restore.

A recovery file will not open or looks incomplete. Do not save over the original. Make another copy of the recovery file, then try opening the copy in Excel. If Excel offers a repair prompt, follow it on the copy. A recovered file may not include every edit, especially if the available recovery point was created before the last save.

Frequently Asked Questions

Can I undo a change in Excel after I have saved?
Usually, yes, if the workbook is still open and the change remains in the Undo history. Use Ctrl+Z on Windows or Command+Z on Mac, then save again when the sheet is correct.

Can I undo changes after closing and reopening the workbook?
Not with the regular Undo button. Check Version History for a OneDrive or SharePoint workbook, or look for a backup or Windows previous version. Without an earlier copy, Excel may not be able to restore the old state.

Does saving clear Excel’s Undo history?
Saving alone usually does not clear it. Closing the workbook, certain operations, or some add-ins can make earlier actions unavailable. The Undo list is temporary, not a permanent record.

How do I restore just one sheet instead of the whole workbook?
Open the earlier version without replacing the current file, then copy the needed sheet or cells into the current workbook. Check formulas and links afterward, and keep a separate copy before editing.

Can AutoRecover bring back edits I saved over?
It is not designed as a guaranteed way to roll back saved edits. Check File > Info > Manage Workbook for any available recovery file, but use cloud Version History or a backup for a dependable earlier copy.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.