Microsoft KB Archive/211922

= How to modify the number of undo levels in Excel =

Article ID: 211922

Article Last Modified on 3/16/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211922





For a Microsoft Excel 97 version of this article, see 162944.

Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



SUMMARY
By default, Microsoft Excel keeps track of 16 "undo" levels. Undo levels provide an undo history for most actions that you perform in Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry.

Note We recommend that you do not increase the number of undo levels beyond 100. The more you increase the number of undo levels, the more random access memory (RAM) Excel requires to store the undo history. This affects the performance of Excel.



MORE INFORMATION
By default, Excel allocates RAM for 16 undo levels. The registry setting that is described in this article lets you change the default value to a value that you specify.

If the undo history is set to zero, no memory is allocated for undoing actions. The higher the undo history value, the more memory Excel allocates for the history. This directly affects the performance of your computer when you run Excel.

Note When you run a Visual Basic for Applications macro, Excel allocates no memory for undoing actions. This feature is disabled for optimization of performance when you run a macro.

To use Registry Editor to change the number of undo levels, follow these steps.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.  Close any programs that are running. Click Start, click Run, type regedit in the Open box, and then click OK. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:

Microsoft Office Excel 2007

Microsoft Office Excel 2003

Microsoft Excel 2002

Microsoft Excel 2000

 On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER. On the Edit menu, click Modify. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.</li> Start Excel. Excel stores an undo history for the number of actions that you specified in step 6.</li></ol>

Additional query words: multiple levels XL2000 XL2002 XL2003 XL2007

Keywords: kbhowto kbui KB211922

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.