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.

Level: Recommended For Novice Users

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. When editing the registry it is highly recommended to run a quick scan for optimization, you can test your system now for free.