• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Maximum

Change undo limit in Excel 2013 and Excel 2010

May 22, 2015 by Admin 3 Comments

Undo

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

image

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

image

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.

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010 Tagged With: Change limit, Excel 2010, Maximum, Undo History, Undo limit

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023