Fix Excel Undo When Ctrl+Z Stops Working or Allows One Undo
Question details
The user needs to understand why Excel Undo stops working or permits only one undo operation.

- Product
- Microsoft Excel for Microsoft 365 and Office 2016
- Device & OS
- not provided
- Scenario
- Using Ctrl+Z to reverse recent changes in an Excel workbook.
- Observed behavior
- Undo may stop working or allow only one operation instead of reversing several recent changes.
Check whether the problem follows ordinary cell edits or a specific command, such as an action on the File menu. Note your Excel version and license type so you can compare behavior accurately.
Check Whether an Action Cleared Excel's Undo History
Use a simple cell-edit test to distinguish normal Undo behavior from an action that clears the history.
Open a new blank workbook, enter different values in several cells, and press Enter after each entry.
Press Ctrl+Z several times, or click Undo on the Quick Access Toolbar, and check whether Excel reverses each edit.
Repeat the test with the command you normally use between edits. Check whether Undo becomes unavailable or displays Cannot Undo afterward.

Test Excel Without Add-ins or Macros
Use this test if Undo fails after ordinary cell edits, even in a new workbook.
Collect Excel Version Details and a Reproducible Example
Use this information when the cause is still unclear or you need help from Microsoft support.
Edit Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue editing with an easy-to-use workspace, making migration straightforward. It does not repair Microsoft Excel's Undo history.

Frequently Asked Questions
Why does Excel show Cannot Undo?
Some actions cannot be reversed and may clear earlier Undo history. Test your usual commands between cell edits and check the Undo button to identify which action causes the change.
Does saving a workbook always clear the Undo history?
Not necessarily. Saving behavior can vary by Excel version and circumstances. Make several cell edits, save the workbook, and test Undo to see what happens in your setup.
Can an add-in or macro affect Excel Undo?
An add-in or macro may affect Undo behavior. Test a blank workbook without running macros; on Windows, you can also start Excel with the excel /safe command and compare the result.
Where can I find my Excel version?
In Excel for Windows, go to File > Account > About Excel. On Mac, choose Excel > About Microsoft Excel. Record the version and build when reporting the issue.




