Microsoft Excel maintains an Undo history that stores certain actions you perform while working on a spreadsheet. This allows you to reverse recent changes without manually restoring the original information.
However, Excel doesn’t maintain this history for every operation. For example, running certain macros, executing VBA procedures, or performing particular actions can clear the Undo stack. Once that happens, pressing Ctrl+Z won’t bring back the previous changes.
The shortcut might also fail because of a faulty keyboard, conflicting software, problematic add-ins, or an issue with your Office installation.
Let’s go through the solutions one by one.
Ctrl+Z Not Working in Excel? Here’s How to Fix It
If Ctrl+Z isn’t working in Microsoft Excel, try the following troubleshooting methods to restore the Undo function.
- Check whether the Ctrl and Z keys are working properly using another application.
- Use the Undo button on the Excel Quick Access Toolbar to check whether the issue is related to the keyboard shortcut.
- Close and reopen Excel to resolve temporary application glitches.
- Check whether an Excel macro or VBA code has cleared the Undo history.
- Start Excel in Safe Mode to identify problematic add-ins.
- Disable recently installed Excel add-ins that might interfere with normal operations.
- Update Microsoft Excel to install the latest available fixes.
- Repair Microsoft Office if the Undo function continues to malfunction.
1: Check Whether Your Keyboard Shortcuts Are Working
The first thing you should check is whether your keyboard is recognizing the Ctrl and Z keys correctly. Sometimes, the problem has nothing to do with Excel itself.
To check this, open another application on your computer, such as Notepad or Microsoft Word. Type a few words into the document and press Ctrl+Z. If the shortcut successfully removes your most recent typing, your keyboard is probably working correctly.
However, if nothing happens, try pressing the left Ctrl key instead of the right Ctrl key. You can also test the Z key separately by typing it into a text field.
If you’re using an external keyboard, disconnect it and reconnect it to your computer. For a wireless keyboard, check its battery level and reconnect the USB receiver if necessary.
You can also open the Windows On-Screen Keyboard by pressing Windows + R, typing osk, and selecting OK. Use the virtual keyboard to test the Ctrl and Z combination.
If the shortcut works with the On-Screen Keyboard but not your physical keyboard, check your keyboard settings or consider updating its driver.
Why this helps: This test determines whether the problem is caused by your keyboard or Excel. It saves you from changing application settings unnecessarily.
2: Use the Undo Button in Excel
If your keyboard works properly in other applications, the next step is to check whether Excel’s Undo command is functioning.
Excel provides an Undo button through the Quick Access Toolbar. This button performs the same basic function as the Ctrl+Z shortcut.
Open your Excel workbook and look at the upper-left corner of the Excel window. You should see a curved arrow pointing to the left. This is the Undo button.
Click it once and check whether Excel reverses your last action. You can also click the small dropdown arrow beside the Undo button to view a list of recent actions that can be reversed.
If the Undo button works but Ctrl+Z doesn’t, the issue is likely related to your keyboard shortcut, keyboard settings, or another application intercepting the key combination.
If the Undo button is grayed out, Excel doesn’t currently have an available action to undo.
You can also check the keyboard shortcut by opening another workbook and making a simple change, such as entering text into an empty cell. Then try Ctrl+Z again.
Important: Don’t use an important workbook for testing. Make a temporary copy or use an empty spreadsheet so you don’t accidentally overwrite valuable information.
3: Close and Restart Microsoft Excel
Sometimes, Excel experiences temporary glitches that affect keyboard shortcuts and other application commands. Restarting the program can help resolve these problems.
First, save your workbook by pressing Ctrl+S. If you’re working with unsaved changes, make sure you save a copy before closing Excel.
Next, close the Excel window. If multiple Excel workbooks are open, close them as well.
If Excel doesn’t close normally, press Ctrl+Shift+Esc to open Task Manager. Find Microsoft Excel under the Processes section, right-click it, and select End task.
However, be careful with this option because any unsaved changes may be lost.
Once Excel has completely closed, reopen it from the Start menu. Open your workbook and make a small test change in an empty cell. Now press Ctrl+Z to see whether the Undo command works.
If the shortcut starts working again, the issue was probably caused by a temporary Excel process or application glitch.
If the problem continues, move on to the next solution.
4: Check Whether a Macro Has Cleared the Undo History
This is one of the most important things to understand when troubleshooting Ctrl+Z in Excel.
If you regularly work with VBA macros, there’s a possibility that a macro has cleared your Undo history.
Excel doesn’t preserve its normal Undo history after certain VBA operations. For example, a macro can perform several changes to your worksheet, but Excel may no longer allow you to reverse those changes using Ctrl+Z.
This means that even if your keyboard is working perfectly, the Undo button may become unavailable after running a macro.
To check whether a macro is responsible, think about what you did immediately before Ctrl+Z stopped working. Did you run a macro, click a custom button, or use an automated Excel tool?
If so, open your VBA editor by pressing Alt+F11. Look through the relevant macro code and check whether it performs operations that modify the workbook.
If you’re familiar with VBA, you can also search for the Application.OnUndo method. This method allows a macro developer to define a custom Undo procedure.
If you aren’t comfortable editing VBA code, avoid changing anything in the editor. Instead, test the workbook without running the macro.
Keep in mind: Excel generally cannot restore its cleared Undo history. If a macro has already removed it, you’ll need to recover the original information through a saved copy, version history, or another available backup.
5: Open Excel in Safe Mode
Excel add-ins provide additional functionality, but sometimes they interfere with normal application behavior. A problematic add-in might affect keyboard shortcuts, spreadsheet operations, or other Excel commands.
To check whether an add-in is causing the problem, start Excel in Safe Mode.
Press Windows + R to open the Run dialog box. Type excel /safe into the box and press Enter.
Excel will now open without loading most startup add-ins, customizations, and certain additional settings.
Open your workbook and test the Ctrl+Z shortcut after making a small change.
If the shortcut works in Safe Mode but fails during normal startup, an add-in or startup customization could be responsible.
You can then close Safe Mode and open Excel normally.
This test is particularly useful because it helps you identify whether the problem is related to Excel itself or something loading alongside it.
6: Disable Problematic Excel Add-ins
If Ctrl+Z works in Safe Mode, you should check your installed Excel add-ins.
Add-ins can extend Excel’s functionality by providing tools for data analysis, formatting, automation, and other tasks. However, outdated or incompatible add-ins may sometimes cause unexpected behavior.
To disable them, open Excel normally and select File > Options > Add-ins.
At the bottom of the window, find the Manage drop-down menu. Select COM Add-ins and click Go.
A new window will display the COM add-ins currently enabled in Excel.
Uncheck the available add-ins and select OK. Restart Excel and test whether Ctrl+Z works.
If the shortcut starts working, one of the disabled add-ins was likely responsible.
To identify the problematic add-in, enable them one at a time. Restart Excel and test the shortcut after enabling each one.
Once you find the add-in causing the issue, leave it disabled or check whether an updated version is available.
You can also repeat this process for Excel Add-ins by selecting Excel Add-ins from the Manage dropdown menu.
Tip: Don’t disable every add-in permanently without checking whether you need it. Some add-ins provide important features for your daily spreadsheet workflow.
7: Update Microsoft Excel
Running an outdated version of Microsoft Excel can sometimes lead to compatibility issues and unexpected application behavior.
Microsoft regularly releases Office updates to improve performance, address bugs, and enhance security. Installing the latest available updates may resolve problems affecting Excel commands and shortcuts.
To update Excel, open Microsoft Excel and select File > Account.
Under Product Information, look for Update Options. Click the drop-down menu and select Update Now.
Wait while Microsoft Office checks for available updates and installs them.
If you don’t see the Update Options menu, your Office installation may be managed by your organization. In that case, contact your IT administrator to check whether updates are controlled centrally.
After the update finishes, restart Excel and open your workbook.
Make a small change in a cell and press Ctrl+Z to check whether the issue has been resolved.
If you’re already running the latest version, continue with the next troubleshooting method.
8: Repair Microsoft Office
If none of the previous solutions work, your Microsoft Office installation might have corrupted or missing program files.
Windows provides repair options that can help resolve problems with Microsoft Excel and other Office applications.
To repair Office, open Settings by pressing Windows + I.
Navigate to Apps > Installed apps in Windows 11. In Windows 10, go to Apps > Apps & features.
Find Microsoft 365 or your Microsoft Office installation in the application list. Click the three-dot menu beside it and select Modify. Depending on your Office version, you may see a Change option instead.
A repair window will appear with two options: Quick Repair and Online Repair.
Start with Quick Repair. This option checks and fixes common Office installation problems without requiring an internet connection.
If Quick Repair doesn’t resolve the issue, run Online Repair. This performs a more comprehensive repair and may require an internet connection.
Keep in mind that Online Repair can take longer and may require you to sign in to your Microsoft account again.
Once the repair process finishes, restart your computer, open Excel, and test the Undo shortcut.
This method is particularly useful when multiple Excel features are malfunctioning, not just Ctrl+Z.
FAQs
1. Why is Ctrl+Z not working in Excel?
Ctrl+Z may stop working because Excel’s Undo history has been cleared, a VBA macro has modified the workbook, an add-in is causing conflicts, or your keyboard isn’t registering the shortcut correctly. Testing the Undo button and opening Excel in Safe Mode can help identify the cause.
2. How do I undo something in Excel without Ctrl+Z?
You can use the Undo button in the Quick Access Toolbar at the top-left corner of Excel. Click the curved left-arrow icon to reverse your most recent action. You can also use its drop-down menu to select multiple recent actions.
The Undo button becomes unavailable when Excel has no supported actions remaining in its Undo history. This can happen after running certain VBA macros or performing operations that clear the Undo stack.
4. Can I recover Excel changes after the Undo history is cleared?
Yes, sometimes. You can check File > Info > Version History if your workbook is stored in OneDrive or SharePoint. You can also check AutoRecover files or previously saved copies. However, Excel cannot directly restore an Undo history that has already been cleared.
5. Does Excel have a limit on how many actions I can undo?
Yes. Excel generally supports undoing up to 100 actions in its standard Undo history. However, certain operations can clear that history before you reach the limit.
6. Why does Ctrl+Z work in Word but not in Excel?
If Ctrl+Z works in Word but not in Excel, your keyboard is probably functioning correctly. The problem may be related to Excel’s Undo history, macros, add-ins, or application settings.
7. Does restarting Excel fix the Ctrl+Z problem?
Restarting Excel can resolve temporary application glitches. However, it won’t restore an Undo history that was already cleared. Always save your workbook before restarting the application.
Final Words
The Ctrl+Z shortcut is essential when working with Microsoft Excel, especially when handling large spreadsheets, formulas, and important business data. When it stops working, you don’t necessarily need to reinstall Excel or make complicated changes to your computer.
Start by checking your keyboard and testing the Undo button. If those methods don’t help, restart Excel, investigate VBA macros, and disable potentially problematic add-ins. You can also try Safe Mode, install Office updates, or repair your Microsoft Office installation.
Remember that Excel’s Undo history can be cleared by certain operations, particularly VBA macros. If that happens, the usual Ctrl+Z shortcut won’t restore your previous changes.
To avoid losing important information in the future, save your work regularly and keep backup copies of important Excel files. If your workbook is stored in OneDrive or SharePoint, take advantage of its version history.