Excel Performance Problems

Fix Excel 2016 When It Allows Only One Undo Step

Kushani NimanthikaKushani Nimanthika Nov 20, 2026 868 views

Question details

The user needs Excel 2016 to retain multiple undo actions instead of only the latest one.

Fix Excel 2016 When It Allows Only One Undo Step
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
The user makes many edits in a workbook and wants to undo more than the most recent action.
Observed behavior
The undo list contains only the latest action, even after many edits.
Before you start

Make several distinct edits in a workbook and open the arrow next to Undo on the Quick Access Toolbar to check the list. Note any add-ins, macros, or other applications running while you work; the repair and Safe Mode steps below apply to Windows.

Solution 1Recommended

Run an Online Repair of Office 2016

Use Online Repair to address a damaged Office installation that may be affecting Excel's undo history.

1
Open the Office installation

On Windows, close Excel, open Settings > Apps, find Microsoft Office 2016, and choose Modify. On some Windows versions, open Control Panel > Programs and Features, select Office, and choose Change.

2
Start the repair

Select Online Repair, choose Repair, and follow the prompts. An internet connection is required. If Online Repair is not offered, use the repair option available for your installation.

3
Test the undo list

Reopen Excel, make several distinct edits, and select the arrow next to Undo to see whether multiple actions are listed.

Run an Online Repair of Office 2016
Free Microsoft Office alternative

Edit Spreadsheets with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working on spreadsheets. Open compatible Excel files in WPS Spreadsheet for an easy transition; it does not repair Excel's undo history.

Undo spreadsheet edits using the Undo button or keyboard shortcutCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree, lightweight office suite for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

How can I see which actions Excel can undo?

Select the arrow next to Undo on the Quick Access Toolbar. The list shows the actions currently available to undo.

How do I open Excel 2016 in Safe Mode?

On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Make several edits and check the Undo list.

Can a macro clear Excel's undo history?

Yes. Some VBA macros can clear the undo history when they run. Compare the Undo list before and after running the macro, or test a workbook without macros.

What if Online Repair is not available?

The options depend on how Office was installed. In the Office Modify or Change dialog, use the repair option offered for your installation, then reopen Excel and test Undo.