Fix Excel 2016 When It Allows Only One Undo Step
Question details
The user needs Excel 2016 to retain multiple undo actions instead of only the latest one.

- 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.
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.
Run an Online Repair of Office 2016
Use Online Repair to address a damaged Office installation that may be affecting Excel's undo history.
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.
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.
Reopen Excel, make several distinct edits, and select the arrow next to Undo to see whether multiple actions are listed.

Test Excel in Safe Mode and Disable Add-ins
Use Safe Mode to check whether an add-in or startup component is interfering with undo history.
Check Macros and Other Applications
Investigate automation or external applications if repairing Office and testing add-ins do not resolve the problem.
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.

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.




