How to Undo in Excel When the Undo Option Is Missing

Errors & fixes · Updated November 20, 2026

If Excel has no visible Undo option, press Ctrl+Z on Windows or Command+Z on Mac to reverse the most recent undoable action. If the shortcut does nothing, check whether you are still editing a cell, whether Excel’s undo history was cleared, or whether you need to recover an earlier file version instead.

What You’ll Need

  • The Excel workbook you want to fix, still open if possible. Excel’s normal undo history is tied to the open session and may not be available after you close the workbook.
  • Access to the file’s saved location. For a workbook stored on OneDrive or SharePoint, you may be able to use Version History. For a local file, check whether you have a backup or an AutoRecover copy.
  • A few minutes to check what changed before trying further edits. If the missing Undo relates to deleted or overwritten content, avoid making additional changes until you have checked recovery options.

Step-by-Step

  1. Try the keyboard shortcut first. In Excel for Microsoft 365 on Windows, press Ctrl+Z once. On a Mac, press Command+Z. Each press normally reverses one recent action, such as entering a value, applying formatting, or deleting a range. Look at the worksheet after each press so you can stop as soon as the unwanted change is reversed. If you are working in Excel for the web, use the same general shortcuts in your browser; the Undo button is also available on the Home tab.
  2. Check whether you are still editing a cell. If you see a text cursor inside the cell or in the formula bar, you may be editing a value rather than working normally in the sheet. Press Esc to cancel the current edit without committing it. If you already pressed Enter or clicked away and the change was committed, use Ctrl+Z or Command+Z to undo it. Esc cancels the edit in progress; it does not usually roll back the last completed worksheet action.
  3. Look for the Undo button in the Quick Access Toolbar. In desktop Excel for Windows, the Undo arrow is usually near the top-left of the window, above or below the ribbon depending on your layout. If it is visible but dimmed, Excel has no available action to undo in the current context. If the toolbar itself is hidden or the button was removed, use the keyboard shortcut while you troubleshoot; the shortcut does not depend on the button being displayed.
  4. Add Undo back to the toolbar if it is missing. In Excel for Microsoft 365 on Windows, open File > Options > Quick Access Toolbar. Set Choose commands from to All Commands, select Undo, and click Add >>. Click OK to save the change. If you also want to undo several recent actions, use the small arrow beside the Undo button, when available, and select the appropriate run of actions. Excel reverses the selected action and the actions above it in the list, so check the selection before confirming. On Mac, use Excel > Settings > Ribbon & Toolbar and look for the Quick Access Toolbar controls; labels and layout can vary slightly by release.
  5. Find out whether the undo history was cleared. Undo may be unavailable if you have just run a VBA macro or another process that clears Excel’s undo history. Closing and reopening a workbook also ends the ordinary session history. Some operations do not support normal undo, so a disabled Undo button is not necessarily a display problem. If the command is dimmed and Ctrl+Z has no effect, do not keep pressing it expecting Excel to reconstruct an older state.
  6. Use Version History for a cloud-stored workbook. If the file is saved in OneDrive or SharePoint, open File > Info > Version History in desktop Excel, or use the workbook’s Version History option in Excel for the web. Review the dated versions and open one that predates the unwanted change. Compare it with the current workbook before restoring it. If you choose to restore an older version, first save a copy of the current file if you may need its newer edits. Version History is not the same as Undo: restoring a version can replace the workbook’s current contents.
  7. Check for a backup or AutoRecover copy if there is no version history. In Excel for Windows, open File > Info and look for Manage Workbook or the recovery options available for that file. The exact labels can depend on how the workbook was saved and whether Excel created a recovery copy. You can also check File > Open > Recent for a recovered workbook. On Mac, check Excel’s recovery prompt after a crash and the file’s saved location for a separate backup. Recovery is not guaranteed, so keep the current file untouched while you look.
  8. Save a recovered copy under a new name. If Undo works, save the corrected workbook. If you restored or opened an older version, use Save As to create a separate file before replacing the working copy. Give it a clear name, such as a date or “recovered,” and open the copy to confirm the data and formatting are correct. This gives you a way back if the recovered version is not the one you intended.

Common Mistakes

  • Assuming the missing arrow means Undo is impossible. The toolbar button can be hidden or removed while Ctrl+Z still works. Try the shortcut before changing workbook settings.
  • Expecting Undo to work after closing the workbook. Excel’s usual undo list is not a permanent history. After closing a file, use Version History, a backup, or a recovery copy rather than expecting the old session’s actions to reappear.
  • Repeatedly pressing Ctrl+Z without checking the result. Each press can reverse another action, including a change you wanted to keep. Press once, inspect the sheet, and continue only if needed. If you undo too far, Ctrl+Y usually redoes the last action that was undone, provided the redo history is still available.
  • Confusing Esc with Undo. Esc cancels an edit that has not been committed. It does not generally restore a value after you have committed the edit and moved on.
  • Restoring an old cloud version without protecting current work. A prior version can omit edits made after its timestamp. Save a separate copy of the current workbook and compare versions before you restore.
  • Continuing to edit after noticing data loss. Further edits can make it harder to identify the right recovery point. Pause, note what is missing, and check available versions or backups before changing more cells.

Tips

  • Use Ctrl+Z immediately after an unwanted change, before switching workbooks or running other commands. For a single cell, you can also type the correct value again if that is safer than undoing a series of actions.
  • Keep the Undo button in the Quick Access Toolbar if you often work with the mouse. The button’s drop-down can help you review recent actions, while the keyboard shortcut is usually faster for one change.
  • For important workbooks, save them in OneDrive or SharePoint if your organization permits it, and check that Version History is available. Cloud storage and AutoSave are useful safeguards, but neither should be treated as a substitute for making deliberate copies of critical files.
  • Before running a macro or automation that may change many cells, save a separate copy. Excel’s normal undo feature does not reverse VBA macro actions, and running a macro can clear the current undo list.
  • If you are unsure whether an action can be undone, make a copy of the workbook before attempting a large repair. This is especially helpful when the change affects many sheets, imported data, or workbook structure.

Troubleshooting

Ctrl+Z does nothing, but the Undo arrow is visible. Check whether the arrow is disabled. If it is, there may be no undoable action, you may be in a context where Undo is unavailable, or the history may have been cleared. Click a normal worksheet cell and try the shortcut once more. If the action was performed by a macro, look for a saved copy or version history instead.

The arrow is missing, but Ctrl+Z works. Restore it through File > Options > Quick Access Toolbar on Windows, as described above. You can still undo with the shortcut in the meantime. If you are using Excel for the web, check the Home tab and the browser window’s available Excel controls rather than desktop Options.

Undo reverses the wrong thing. Excel reverses actions in sequence, not by letting you pick any individual past change. Use Ctrl+Y to redo if that option is available, then stop and consider whether correcting the affected cells directly or opening a prior version is safer. If a sequence of unrelated actions has occurred since the mistake, a version copy may be more practical than unwinding every action.

The data was deleted and the workbook has already been closed. Reopen the file and inspect Version History if it is stored on OneDrive or SharePoint. For a local workbook, check for a backup or recovery file using Excel’s File > Info and File > Open > Recent areas. If no earlier copy exists, Excel may not be able to restore the deleted content. Avoid overwriting any recovery copy you do find.

You cannot tell which version contains the right data. Open candidate versions separately and compare the relevant sheet, cells, and dates before restoring. If necessary, save each candidate with a different filename. This is safer than replacing the current workbook based only on a version’s timestamp.

Frequently Asked Questions

What is the shortcut to undo in Excel?
Use Ctrl+Z on Windows and Command+Z on Mac. In Excel for the web, the shortcut or the Undo control on the Home tab can reverse a recent supported action.

Why is Undo greyed out in Excel?
Excel may have no recent action to reverse, the current action may not support Undo, or the undo history may have been cleared. Running a macro can clear that history. Try the shortcut once, then check Version History or a backup if the change cannot be reversed.

Can I undo after saving the workbook?
Often, you can still undo ordinary actions while the workbook remains open; saving by itself is not a reliable reason to assume Undo is gone. But the undo list is not a permanent record and is generally lost when you close the workbook. For an earlier saved state, use Version History or a backup.

Can I undo after closing and reopening Excel?
Usually not with the ordinary Undo command. That session’s action history is not retained as a full timeline. Check cloud Version History, an AutoRecover file, or a separate backup instead.

Can I undo deleting a worksheet?
If the deletion just happened and Undo is still available, press Ctrl+Z on Windows or Command+Z on Mac promptly. If you saved, closed the workbook, or the undo history was cleared, look for a prior version or backup. Check that the recovered version contains the sheet before replacing your current file.

Does Undo work for macros?
Excel’s regular Undo command does not reverse changes made by VBA macros. A macro can also clear the existing undo history. Save a copy before running a macro, and use that copy or a suitable earlier version if the macro makes an unwanted change.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.