You can undo far more than the last 10 actions in Excel; modern versions of Excel store up to 100 undoable actions by default, and this limit can even be increased via a Windows Registry tweak.

What Excel Actually Allows

  • Excel and other Office apps keep an undo history of the last 100 actions by default.
  • You can step back through those actions using:
    • Ctrl + Z repeatedly
    • The Undo arrow on the Quick Access Toolbar, where you can drop down and select multiple steps to undo at once.
  • The myth that “in Excel you can undo only the last 10 actions” likely comes from:
    • Older setups or specific corporate configurations
    • Confusion with the fact that the toolbar visually lists around 16–20 recent actions, even though Excel remembers more in the background.

Changing The Undo Limit (Windows Desktop)

If 100 steps still feel limiting, Windows users can increase or decrease the limit through the Registry.

  1. Open Registry Editor (Win + R → type regedit).
  1. Navigate to the Office Excel key for your version (e.g. Office\16.0\Excel\Options).
  1. Create or edit a DWORD value named UndoHistory.
  1. Set its value (Decimal) to the number of actions you want, such as 150 or 200.
  1. Restart Excel so the new limit applies.

Note: Very high values can use more memory and may affect performance on large workbooks, so it is safer to increase gradually rather than jump to an extreme number.

Cases Where Undo Won’t Work

Even with a large undo history, some actions in Excel cannot be undone, or they clear the undo stack.

  • Running certain macros or VBA procedures often flushes the undo history , making Undo greyed out afterward.
  • Some operations (like saving in certain contexts, data connections, or external automation) can also clear or bypass the undo list.
  • A few actions, such as using specific functions or commands, cannot be repeated or undone in the same way, and Excel may show “Can’t repeat”.

Forum & “Trending Topic” Angle

The phrase “in excel you can undo only the last 10 actions” shows up in forum posts and Q&A threads where users are either citing much older behavior or misreading how many items appear in the interface.

  • Recent tutorials and how‑to articles emphasize that:
    • Excel generally allows up to about 100 undos by default.
* Power users often tweak this limit when working with complex models, dashboards, or repeated bulk edits.
  • As of the mid‑2020s, “how to undo more in Excel” remains a recurring topic in blogs, YouTube tutorials, and help sites, reflecting continued confusion around the default limit and registry tweak.

Mini FAQ

Q: So is the statement “in Excel you can undo only the last 10 actions” true?

  • No. The realistic modern limit is about 100 actions by default, not 10.

Q: Why do I sometimes seem to undo only a few steps?

  • The undo history might have been cleared by a macro or certain operations, or you might be hitting the top of the list that is currently stored.

Q: Can Excel Online do the same?

  • Excel Online also supports multiple undos, but the exact behavior and limit can differ from the desktop app, and is more tightly bound to the browser/session environment.

Information gathered from public forums or data available on the internet and portrayed here.