Change undo limit in Excel 2013 and Excel 2010


As per the Excel Specifications and limits the maximum limit for undo in Excel 2010 is set to 100. In the previous version of Excel this was set to 16. The maximum limit value is fixed but you can increase or decrease this limit by modify registry settings.

Please Note:- Changing Registry Settings is not recommended and do this with at most caution while trying these changes.

To change the undo maximum limit, Open Windows Registry Editor and then navigate to the following path

HKEY_CURRENT_USER –> Software –> Microsoft –> Office –> 14.0->Excel->Options

Create a new DWORD value with the key name as UndoHistory


Then modify UndoHistory by setting the Base as Decimal and value as 16. Click the OK button to save the changes.


This would decrease the number of undo same as the previous of Excel. You can also increase the undo limit from 100 to 200 for Excel 2010 by changing the above created Windows Registry key.

In Category: Excel 2010, Excel 2013, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 3 Comments
  • Tolga May 16, 2013, 1:02 pm

    Can you make a Mac OS X version of this as well?

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.