Office Settings & Configuration

Fix Excel Undo When Ctrl+Z Stops Working or Allows One Undo

Bushra ParveenBushra Parveen Nov 14, 2026 868 views

Question details

The user needs to understand why Excel Undo stops working or permits only one undo operation.

Fix Excel Undo When Ctrl+Z Stops Working or Allows One Undo
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.
Before you start

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.

Solution 1Recommended

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.

1
Make several cell edits

Open a new blank workbook, enter different values in several cells, and press Enter after each entry.

2
Test Undo repeatedly

Press Ctrl+Z several times, or click Undo on the Quick Access Toolbar, and check whether Excel reverses each edit.

3
Identify the interruption

Repeat the test with the command you normally use between edits. Check whether Undo becomes unavailable or displays Cannot Undo afterward.

Check Whether an Action Cleared Excel's Undo History
Some actions cannot be undone: Certain commands, including some actions on the File menu, can clear earlier Undo history. Saving behavior can vary by Excel version and circumstances, so test the specific action rather than assuming every save clears the history.
Free Microsoft Office alternative

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.

Use familiar Undo controls while editing spreadsheetsOpen and edit Microsoft Excel formats such as XLSX and XLSWork in a familiar, easy-to-use interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.