Though Microsoft Excel permits customers to undo motion 6 occasions, you may improve or lower this number with the assist of this information. It’s doable to modify the number of Undo levels in Excel utilizing the Registry Editor. Here’s what you want to do in the Home windows Registry to get issues performed.
Like another applications, which permit customers to edit information, you may undo adjustments in accordance to your necessities. Let’s assume that you’ve got made a number of incorrect adjustments in your spreadsheet. One of the best ways to get rid of them is through the use of the Undo possibility. Nevertheless, the downside begins while you want to undo adjustments greater than six occasions.
Even in case you are utilizing the newest model of Microsoft Excel, you gained’t give you the option to undo adjustments greater than six occasions. That’s as a result of Microsoft Excel allocates RAM for storing solely six earlier adjustments. When you improve this number, Microsoft Excel will begin utilizing extra RAM than the default setting. In different phrases, should you shouldn’t have a lot RAM, you’ll have lagging whereas utilizing Microsoft Excel.
Nevertheless, at occasions, you may want to allow extra undo levels than the default one. In such conditions, you may comply with the Registry Editor information to get the change performed. As you’re going to make adjustments in the Registry Editor, it’s extremely really useful to create a System Restore level.
How to modify the number of Undo levels in Excel
To alter or modify the number of Undo levels in Excel, comply with these steps:
- Press Win+R to open the Run immediate.
- Sort regedit > hit the Enter button.
- Click on on the Sure button.
- Navigate to Microsoft in HKCU.
- Proper-click on Microsoft > New > Key and set the identify as workplace.
- Repeat these steps to create these sub-keys: 16.0 > excel > choices.
- Proper-click on choices > New > DWORD (32-bit) Worth.
- Set the identify as UndoHistory.
- Double-click on it and choose the Decimal possibility.
- Select a worth between 0 to 100.
- Click on the OK button.
To be taught extra about these steps, proceed studying.
First, you want to open the Registry Editor in your pc. For that, press Win+R > kind regedit > hit the Enter button, and click on on the Sure possibility on the UAC immediate.
Then, navigate to this path:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoft
Right here, you want to create a number of sub-keys. For that, right-click on the Microsoft key, choose New > Key and identify it as workplace.
Then, repeat the identical steps and create a sub-key beneath the workplace key, and identify it 16.0. Following that, create the subsequent sub-keys and identify them excel and choices.
As soon as the following path is prepared, you want to create a REG_DWORD worth:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0exceloptions
For that, right-click on choices > New > DWORD (32-bit) Worth and set the identify as UndoHistory.
Subsequent, right-click on this REG_DWORD worth and select the Decimal possibility. Then, set the Worth information between 0 to 100.
Notice: You’ll be able to set greater than 100 undo levels. Nevertheless, the extra you assign, the extra RAM you want to allocate for Excel. That’s the reason it isn’t really useful to set a Worth information of greater than 100.
Lastly, click on the OK button and restart your pc to get the adjustments.
How many times can you Undo in Excel?
By default, Excel allows users to undo changes up to 6 times. However, it is possible to change the number of undo levels in Excel. For that, you need to use the Windows Registry. A detailed guide is mentioned here, and it is recommended to follow that to get things done.
Learn:
Can solely undo as soon as in Excel?
No, the default setting allows customers to undo adjustments up to six occasions. Nonetheless, you may change this setting with the assist of the Registry Editor. For that, you want to create a REG_DWORD worth in the HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0exceloptions key and set the Worth information between 0 and 100.
