XL2000: How to Modify the Number of Undo Levels

• Microsoft Excel 2000

SUMMARY

By default Microsoft Excel 2000 keeps track of 16 undo levels, which provide an undo history for most actions you perform in Microsoft Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. Microsoft recommends that you do not increase the number of undo levels beyond 100.

NOTE: The more you increase the number of undo levels the more random access memory (RAM) Microsoft Excel requires to store the undo history. This affects the performance of Microsoft Excel.

MORE INFORMATION

By default, Microsoft Excel 2000 allocates RAM for 16 undo levels. The registry setting described in this article allows you to change the default to a value 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 Microsoft Excel allocates for the history. This directly affects the performance of your computer when you run Microsoft Excel. NOTE: When you run a Visual Basic for Applications macro, Microsoft Excel allocates no memory for undoing actions. This feature is disabled for optimization and performance when you run a macro. To use the Registry Editor to change the number of undo levels under Microsoft Windows 95, Windows 98, and Microsoft Windows NT 4.0, use the following steps:

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

1. Close any programs that are running.



2. On the Start menu, click Run. Type regedit and click OK.



3. In the Registry Editor, expand the following key:
   
   HKey_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options



4. On the Edit menu, point to New and click DWORD Value. With New Value #1 selected, type UndoHistory, and then press ENTER.



5. On the Edit menu, click Modify. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 for Value. Click OK and quit the Registry Editor.



6. Start Microsoft Excel 2000. Microsoft Excel stores an undo history for the number of actions you specify in step 5.

REFERENCES

For more information about undoing an action, click Microsoft Excel Help on the Help menu, type undo in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Then click to select the Undo mistakes topic.

Additional query words: multiple levels XL2000

Keywords : kbui kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto