If Undo or Redo is unavailable in Excel, first check the Undo and Redo arrows on the Quick Access Toolbar and try Ctrl+Z or Ctrl+Y on Windows. The buttons are often disabled because Excel has no eligible action in its current undo history, or because a macro or another operation has cleared that history.
Start with the quick checks
Before troubleshooting the workbook, confirm that Excel is the active application and that you are working in the workbook where you made the change. A click in another program or a different workbook can make a shortcut appear ineffective. On Windows, press Ctrl+Z to undo and Ctrl+Y to redo. On a Mac, use Command+Z and Command+Y. You can also click the curved-arrow icons near the top-left of the Excel window.
Look at whether the arrows are greyed out. If Undo is grey, Excel currently has no recorded action it can reverse. If Undo works but Redo is grey, there may be nothing to redo: Redo becomes available after you undo an action, and a new edit usually replaces the redo path.
- Click a blank cell and try the shortcut again, in case focus is in a dialog, another application, or an edit field.
- Check that you are not still editing a cell. Press Enter to commit the edit, then undo it; press Esc to cancel an uncommitted edit instead.
- Try the toolbar arrow rather than the keyboard. This helps distinguish a shortcut or keyboard-layout problem from a missing undo history.
How Excel’s undo and redo history works
Excel keeps a temporary sequence of certain actions made during the current editing session. Undo walks back through that sequence; Redo reapplies actions you have just undone. The small menu beside the Undo arrow can show recent actions. Choosing an older item generally reverses that action and the subsequent actions in the list, so inspect the list before selecting one.
This history is not a permanent, complete record of every workbook change. It is different from cloud version history, and it is not a substitute for a backup. Closing the workbook and opening it again does not restore the previous session’s Undo list. Also, not every operation is reversible through the ordinary buttons. Excel may disable the controls when there is no supported action to undo, even though the workbook has changed in some other way.
Redo is not a general “repeat the last thing” button. In Excel, Ctrl+Y is used to redo an action that was undone. F4 can repeat certain last actions in some contexts, but it does not recover an erased redo history and is not a reliable replacement for Redo.
Check whether a macro cleared the history
A common reason the Undo list suddenly disappears is that a VBA macro has run. Excel’s normal undo history does not track the individual changes made by a macro, so running one clears the standard history. This can happen when you click a macro button, run a command from the Developer tab, or open a workbook that runs code in response to an event, depending on its settings.
If the history vanished just after a macro, Ctrl+Z is unlikely to reverse its results. Do not keep trying random commands: they may change more data without restoring the original state. If the workbook is stored in OneDrive or SharePoint, check its version history for an earlier copy. Otherwise, look for a separate backup or saved copy. Macros can be designed with their own custom undo behavior, but that requires the workbook’s code to provide it; Excel’s standard Undo button does not automatically reverse VBA changes.
Actions and situations that can make Undo unavailable
Some commands or operations are not represented in the normal undo sequence, and actions that interact with code or external processes can interrupt it. The exact behavior can depend on the operation and Excel version, so a disabled button does not by itself identify what happened. Consider what changed immediately before the controls stopped responding.
- A macro ran: this is a particularly common reason the undo list is cleared.
- You opened or switched to another workbook: verify which workbook is active and whether the edit was made in that file.
- You closed and reopened the file: the session’s undo sequence is not a permanent workbook record.
- You are editing a cell or dialog: finish or cancel that interaction before expecting the normal worksheet shortcut to act.
- A command was blocked or not committed: a protected sheet, for example, may prevent an edit rather than create an action that Undo can reverse. Resolve the protection or permission issue first.
Saving alone is not a reliable way to diagnose an Undo problem. Excel’s undo history is separate from whether a file is saved, and the important clue is often whether an action that cannot be tracked—especially a macro—ran. If the change is consequential, preserve the current file under another name before experimenting.
When the shortcut appears to do nothing
If the toolbar arrow is enabled but Ctrl+Z or Ctrl+Y has no visible effect, check keyboard focus and the target of the action. A shortcut can be intercepted by another application, a remote desktop session, or a keyboard utility. In Excel for the web, browser behavior and focus can also affect shortcuts; clicking the Undo or Redo arrow in Excel’s interface is a useful test.
For an edit in a cell, Enter commits the value and Esc cancels the current uncommitted edit. For example, if you are typing a replacement value into a cell and have not pressed Enter, Esc cancels that in-progress entry; Ctrl+Z is intended to undo a committed action. If you have already pressed Enter, select the cell and use Undo. Confirm the result visually, especially when undoing a paste or a multi-cell operation.
If Excel itself seems unresponsive, save a copy if possible, then wait briefly for a calculation or external-data operation to finish. Avoid repeatedly pressing Undo while the application is busy: when it responds, multiple queued keystrokes could reverse more actions than intended. If the issue occurs in every workbook, restart Excel and test a new blank workbook. If it happens only in one file, focus on that file’s macros, protection, and storage history.
Recover a change when Undo cannot help
When standard Undo is unavailable, recovery depends on where and how the workbook was saved. For a workbook stored on OneDrive or SharePoint, version history may let you inspect or restore an earlier saved version. In many Microsoft 365 desktop builds, open File > Info > Version History; you can also find Version History from the workbook name or file menu in some current interfaces. The exact entry point can vary with the account and update.
Before restoring an older version, consider opening it separately or copying the needed cells into the current workbook. Restoring a whole version can discard later work by you or collaborators. If the workbook is on a local drive, check File Explorer’s backup or file-history options, your organization’s backup system, or a manually saved copy. AutoSave and AutoRecover can help with some unsaved or interrupted work, but neither should be treated as a guaranteed, detailed undo log.
For a small accidental edit, compare against a known copy, source data, or a colleague’s version if available. Be careful with formulas and linked data: typing a value that looks right may overwrite a formula or remove a relationship. Save a separate copy before manually repairing a large range so you can return to the current state if the repair is wrong.
Differences in Excel for Mac and the web
On Excel for Mac, the usual shortcuts are Command+Z for Undo and Command+Y for Redo. Use the toolbar arrows if your keyboard layout or another app makes those shortcuts unreliable. The core limitation is the same: the buttons operate on available undo history, not on every change ever made to a file.
Excel for the web also has Undo and Redo controls in its interface. If keyboard commands do not work as expected in a browser, use those controls and make sure the workbook has focus. Cloud storage may provide version history, but collaborative editing adds another reason to check carefully before restoring: a previous version can include other people’s work, not just your own. Coordinate before replacing a shared workbook with an older version.
Reduce the risk of losing reversible work
For important edits, make a copy before running macros, importing data, or making broad changes. If a macro is part of a routine, save the workbook first and confirm its purpose before running it. For workbooks shared with others, use cloud version history as a recovery option and avoid restoring a full version until you know which changes it contains.
When Undo seems to fail, pause and identify the last action that definitely worked. Check the toolbar state, test one deliberate undo, and verify the affected cells before continuing. This is safer than repeatedly pressing shortcuts or making new edits that could further change the redo sequence. If a macro or non-reversible operation has already removed the history, switch to version history or a backup rather than expecting Ctrl+Z to recover it.
Frequently Asked Questions
Why is the Undo button greyed out in Excel?
Excel has no available action in its current undo history, or an operation such as running a macro has cleared that history. Check whether you are in the correct workbook and whether an uncommitted cell edit is still active.
What is the Redo shortcut in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Y. On Mac, use Command+Y. Redo reapplies an action you just undid; it does not repeat arbitrary past work.
Why did Excel’s Undo history disappear after I ran a macro?
Excel’s regular undo system does not record a macro’s individual changes, so running VBA clears the ordinary undo history. Use a backup or an available workbook version to recover if the macro made an unwanted change.
Can I undo changes after closing and reopening a workbook?
Usually not with the standard Undo button, because that history belongs to the editing session. Look for OneDrive or SharePoint Version History, a local backup, or an AutoRecover copy where available.
Does Excel for the web have Undo and Redo?
Yes. Use the Undo and Redo arrows in the Excel interface, especially if a browser or keyboard setting interferes with shortcuts. As with desktop Excel, these controls are not a permanent record of every workbook change.
Related
- Quick Key to Zoom In Excel: Shortcuts and Zoom Options
- Quick Schedule Maker in Excel: Build One Fast
- Excel Strikethrough Shortcut: Quick Key and How to Use It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Page Break Not Going Away? Fix Persistent LinesIf an Excel page break will not go away, first switch to View > Normal; if the line…
- Excel Error Sound: Why It Plays and How to Stop It in WindowsExcel’s error sound is usually an Office feedback beep or a Windows system sound triggered when you perform…
- Excel MATCH Function Not Working With Numbers? FixesIf Excel’s MATCH function cannot find a number, first check whether the lookup value and the numbers in…
- Excel Solver Not Opening? Fix the Add-InIf Excel Solver is not opening, enable its add-in in desktop Excel: go to File > Options >…
- Excel TAKE Function Not Working? Fix the Common CausesIf Excel’s TAKE function is not working, first confirm that your Excel version supports it, then check the…
- Excel Custom Number Format Not Working? FixesIf an Excel custom number format is not working, first confirm the selected cells contain numbers or dates…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.