Excel users often find the default undo limit insufficient, especially when working on complex data models or making numerous formatting changes. The undo history is a temporary memory cache that stores your recent actions. This article explains how to modify a Windows Registry setting to increase the number of undo steps available in Excel.
Key Takeaways: Increasing Excel’s Undo Limit
- Registry Editor (regedit.exe): The only method to change the undo limit involves editing a specific Windows Registry key for Excel.
- UndoHistory DWORD value: This registry entry controls the maximum number of actions stored in Excel’s undo stack.
- Close all Office applications: You must completely exit Excel and other Office apps before making the registry change for it to take effect.
How Excel’s Undo Feature Works
Excel’s undo feature stores a sequential list of your recent commands and edits in your computer’s memory. By default, this list holds 100 actions. This limit balances performance with functionality, as storing more actions uses more system resources. The undo history is session-specific and is cleared when you close the workbook or the application. This feature applies to most actions, including data entry, formatting, inserting or deleting rows, and formula changes. However, some major actions like saving a file or running certain macros cannot be undone and will clear the existing history.
Prerequisites for Changing the Undo Limit
You must have administrative rights on your Windows computer to edit the Registry. Always create a backup of the Registry before making changes. The modification applies to the Excel application itself, not individual files, and will affect all workbooks you open. The change requires a restart of Excel to become active.
Steps to Modify the Undo Limit via the Registry
Follow these steps carefully to increase the maximum number of undo steps. Ensure Excel is not running in the background.
- Open the Windows Registry Editor
Press the Windows key + R to open the Run dialog. Typeregeditand press Enter. Click Yes if prompted by User Account Control. - Navigate to the Excel Options Key
In the Registry Editor, use the left pane to browse to this path:HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options. The “16.0” corresponds to Office 2016, 2019, and Microsoft 365. For Office 2013, use “15.0”. For Office 2010, use “14.0”. - Create a New DWORD Value
Right-click in the right-hand pane of the Registry Editor. Select New > DWORD (32-bit) Value. Name the new valueUndoHistory. - Set the Desired Undo Limit
Double-click the newUndoHistoryvalue. Select the Decimal base. In the Value data field, enter your desired number of undo steps, such as 200 or 500. Click OK. - Close the Registry and Restart Excel
Close the Registry Editor. Open Excel to a new or existing workbook. The new, higher undo limit is now active for your user account.
Common Mistakes and Limitations to Avoid
Setting the UndoHistory Value Too High
Entering an extremely high number like 10000 can cause Excel performance issues. The application may become slow or unresponsive as it tries to manage the large undo cache in memory. A value between 150 and 1000 is recommended for most users. Test stability after making a large increase.
Editing the Wrong Registry Key or Value Name
Creating the DWORD in the wrong Office version folder, such as 16.0 for an Office 2013 installation, will have no effect. Misspelling the value name, for example typing “UndoHistroy”, will also not work. Always verify the exact path and spelling.
Expecting Unlimited Undo for All Actions
The increased limit still only applies to actions that are normally undoable. Major actions like saving, printing, or running most VBA macros will continue to clear the undo stack. The history is still tied to your current Excel session and is lost when you close the application.
Default Undo Limit vs. Increased Limit
| Item | Default Configuration (100 Steps) | Custom Increased Limit |
|---|---|---|
| Maximum Actions Stored | 100 | Up to 9999 (practical limit is lower) |
| Performance Impact | Minimal memory use | Higher memory use with large values |
| Configuration Method | Built-in, no setup required | Manual Windows Registry edit |
| Risk Level | None | Medium – incorrect edits can affect system stability |
| Action Persistence | Lost on save/close | Lost on save/close |
You can now reverse many more actions in a single Excel session by editing the UndoHistory registry value. For related performance tuning, explore disabling hardware graphics acceleration in File > Options > Advanced. Remember that using the F4 key to repeat your last action does not consume an undo step.