Modify the undo limit in Microsoft Office

0
19


monticello / Shutterstock.com

Microsoft Office stores your last 100 actions in Word, Excel, or PowerPoint. This means that you can undo up to 100 of your previous actions. You can modify this undo limit by making a small change to the Windows Registry.

Why you should (or shouldn’t) change the undo limit

There are good arguments why both should or shouldn’t change the undo limit in Microsoft Office. Both arguments have pros and cons, so carefully consider which one works best for you before making a decision.

By default, you can undo up to 100 of your previous actions in Word, Excel, or PowerPoint. In most cases, this is a good place to be. But what if you want unlimited undos? Well, you can do that, but at a cost. A certain amount of RAM is already allocated to the Office application for its default limit of 100. If you increase this number, more RAM is required when running the program. This could negatively affect your computer’s performance while the application is running. On the other hand, if you have a strong machine that can handle the extra RAM allocation, you can feel safe knowing that you can undo over 100 of the above actions.

Another reason you might want to change the undo limit is if you think 100 is too much for the undo limit and you want to change that to save on RAM allocated for the program. For example, you can change the undo limit to 20, using less RAM when running the application, but this leaves less room for error when working.

If you’re happy with the default undo limit, and if your machine works fine when running one of the applications, it may be best to leave it as is.

RELATED: Top 10 Registry Hacks for Windows 10

How to modify the undo limit

If you’ve decided you want to change the undo limit for an Office app, press Windows + R to open the Run app, type “regedit” in the text box, and then click “OK.”

Open the registry from Run.

Once in the Registry, navigate to this file path:

HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0<Office App>Options

Where <Office App> that is, you will choose Word, Excel, or PowerPoint. Also, note that 16.0 it may differ depending on the version of Office you’re using.

The file path to edit the undo limit.

Once you are in the “Options” subfolder of the Office application, right-click anywhere on the right side of the Registry, hover over “New” and then click “DWORD (32-bit) Value “.

Select the DWORD option.

Once selected, a new value will appear. Name this value “Undo History” and press the Enter key.

Name the new value UndoHistory.

Right-click on the newly created “Undo History” and then in the menu that appears, click “Modify”.

A dialog box will appear. Enter the desired undo limit in the “Data Value” box, select “Decimal” in the Base group, and then click “OK” or press Enter.

Enter the data for the new value.

Your undo limit is already set. Note that you’ll need to repeat this process for each Office application in which you want to change the undo limit.

RELATED: How to undo, redo or repeat an action in Microsoft Excel