Set the number of times the Microsoft Excel is able to undo the operations or command

This setting lets you set the number of times, the Excel is able to undo the operations or command.

Click Here to Run a Free Scan for None Related Errors

Description:
The default value for undo levels is 16 but this number can be as high as 100. The undo value directly affects the performance of your computer, when you are using microsoft excel. It takes higher ram to store the history. Therefore, it is better to keep it around 20. For this, go to start > run menu, enter regedit and navigate to the registry path listed below. If the subkeys \10.0\excel\options is not present, create it as explained below. Then, create a dword value name undohistory, if this value does not exist. Now, right-click and modify the value data box with the number of times (decimal value), you want to undo previous commands like 1 to 100. Click ok and close the registry editor. Logoff or restart your system.

Level: Recommended For Novice Users

First, click the 'Start' button, and select 'Run'. In the resulting dialog box, type "regedit".

Second, go to the <b>[HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\]</b> key, right-click on the right pane and click on "New > DWORD Value" to create a new DWORD value with the name "UndoHistory".

Third, right-click on the 'UndoHistory' DWORD value and click on "Modify".

Finally, enter the number you want and click on 'OK'.