Home >Common Problem >How to modify the number of undo levels in Excel

How to modify the number of undo levels in Excel

WBOY
WBOYforward
2023-04-13 17:04:07980browse

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.

How to increase the number of UNDO levels in Microsoft Excel

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 clicking

Yes.

How to modify the number of undo levels in Excel#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

Options, right-click

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 How to modify the number of undo levels in ExcelUndoHistory and open it by

double click Edit PropertiesWindow.

Step 7: In the edit window, enter a number in the How to modify the number of undo levels in ExcelValuable 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. How to modify the number of undo levels in Excel

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!

Statement:
This article is reproduced at:yundongfang.com. If there is any infringement, please contact admin@php.cn delete