Home >Common Problem >How to modify the number of undo levels in Excel
Whenever users try to draft any document, whether using Excel, Word, PowerPoint, etc., they cannot avoid making mistakes while typing or calculating. These things happen to everyone, what should we do? Yes! We try to undo it by simply pressing the Ctrl Z key.
But have you ever thought about how many times you can perform undo levels while using any MS office product like Excel ? Well, the default setting is 20, which means the user can undo the level up to 20 times.
What if we told you that you could not only undo levels to 20 but also to 100? Wouldn't that be great? Yes, it is possible to do this. But this may slightly reduce system performance, since the undo history up to 100 needs to be stored in RAM, which will be used for the undo level of 100.
If you are here looking for how to increase the number of undo levels in Excel, then this article will guide you through the steps.
Note – Please refer to this article to export a backup of the registry files on your system. If you save a backup of your registry file, you can always restore it later if you have problems editing it. If the registry files are not backed up, this can cause some serious problems in your system.
Step 1: By pressing the Windows R key and typing regeditOpen the Registry Editor. Step 2: Now press
Enter and continue accepting any UAC prompts that appear on the screen by clickingYes.
#Step 3: First, you need to clear the address bar of the Registry Editor window.
Step 4: Then, type the following lines into the address bar and press
Enter key. HKEY_CURRENT_USER\Software\Microsoft\Office.0\Excel\Options
Step 5: Once you reach the registry key named
it and select New > ## from its context menu #DWORD (32-bit) Value as shown below.
Step 6: Now rename the newly created DWORD value to UndoHistory and open it by
double click Edit PropertiesWindow.
Step 7: In the edit window, enter a number in the Valuable Data
field to increase the undo level in Excel.Note
– We do not recommend entering more than 100 as it will use more RAM to store undo history.Step 8: When completed, click "OK".
#Step 9: After that, you can close the Registry Editor window.
Step 10: Then restart the system once. Step 11: After the system starts, you can open the excel application on the system and check if it allows you to undo more levels.The above is the detailed content of How to modify the number of undo levels in Excel. For more information, please follow other related articles on the PHP Chinese website!