How to Fix If Undo and Redo in Excel Are Not Working (3 Simple Solutions)

Solution 1 – Open Excel in Safe Mode

STEPS:

• Go to the Windows search bar.
• Enter Excel.exe /Safe.
• You’ll get the application, as shown below.
• Press it.

You can follow another process to open the Excel file in safe mode.

• Press and hold down the Ctrl key.
• Double-click the desired Excel file to open it.
• You’ll get a dialog box, as shown in the following picture.
• Press Yes.

• It’ll open Excel in Safe Mode.
• The file name and the tabs’ background are White, showing they are in safe mode.

Read More: How to Redo in an Excel Sheet

Solution 2 – Modify Undo Level

STEPS:

• Click the Search taskbar in Windows.
• Type Run.
• The Run dialog box will pop out.
• In the Open box, input regedit.
• Press Enter.

• It’ll return the Registry Editor window.
• Expand HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options. This could be different for other office versions.
• Go to Edit ➤ New ➤ DWORD Value.
• Select New Value #1.
• Type UndoHistory.
• Press Enter.
• Click Edit ➤ Modify.
• As a result, a new dialog box will appear.
• Choose Decimal under Base.
• Type a value (0 to 100) in the Value box.
• Press OK.
• Close the program and start Excel.

This will solve the undo and redo not working issue.

Method 3 – Relocate Undo and Redo

Updating your MS Office version may change the usual place for Undo and Redo buttons. In that case, you won’t be able to find the buttons in their previous position. Which may confuse us. In the following picture, the buttons are in their usual spot.

After updating the office app, you may see the undo and redo buttons on the left side of the Clipboard section under the Home tab.

Download the Practice Workbook

Download the following workbook to practice.

<< Go Back to Learn Excel