Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to modify the number of undo levels in Excel
Article ID: 211922 - View products that this article applies to.
This article was previously published under Q211922
For a Microsoft Excel 97 version of this article, see 162944
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.
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.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows