Ctrl+Z Not Working in Excel? Here’s How to Fix It

Microsoft Excel makes it easy to correct mistakes while working with spreadsheets. Whether you accidentally delete important data, change a cell’s formatting, overwrite a formula, or remove an entire row, the Undo feature (Ctrl+Z) can help you reverse the last action without manually fixing everything.

However, sometimes you may press Ctrl+Z repeatedly, but nothing happens. 

In other situations, Excel may undo only certain actions, disable the Undo button, or fail to restore changes you made a few moments earlier.

In this guide, we’ll explain why Ctrl+Z is not working in Excel and walk you through practical solutions, even if you’re completely new to Excel.

Ctrl+Z Not Working in Excel

If Ctrl+Z is not working in Excel, first check whether the Undo button is available under the Home tab. If it isn’t, save your workbook, check whether a macro or add-in is interfering with the Undo feature, and restart Excel. You can also test the keyboard shortcut, disable problematic add-ins, and check whether your recent action supports undoing.

Excel’s Undo feature doesn’t work with every operation. Certain actions, such as running VBA macros, deleting worksheets, and performing some external data operations, can clear the Undo history.

Before trying the solutions below, remember that pressing Ctrl+Z is different from restoring a previously saved version of a workbook. Undo only reverses supported recent actions.

Let’s look at the steps you can follow to get it working again.

1. Check Whether the Undo Button Is Available

The first thing you should do is check whether Excel’s Undo feature is available. Sometimes, the keyboard shortcut isn’t the problem. Excel may simply have no supported action left to undo.

To check this, open the Excel workbook where you’re experiencing the problem.

Look at the Quick Access Toolbar, usually located near the top-left corner of the Excel window. Find the curved arrow pointing toward the left. This is the Undo button.

Click the Undo button once and see whether Excel reverses your last action.

If the button is gray or unavailable, Excel doesn’t currently have an action in its Undo history that it can reverse.

You can also open the Home tab and check whether the Undo option is available in your Excel interface.

If the button works but Ctrl+Z doesn’t, the issue may be related to your keyboard shortcut or keyboard settings.

2. Check Whether You’re Editing a Cell

Another common reason Ctrl+Z appears not to work is that you’re currently editing a cell.

When you double-click a cell or press F2, Excel enters Edit Mode. In this mode, you’re editing the contents of the cell rather than working with the entire worksheet.

For example, suppose cell A1 contains the text “Monthly Expenses.” You double-click the cell and accidentally delete the word “Expenses.”

If you press Ctrl+Z while still editing the cell, the shortcut may behave differently than you expect.

To fix this, press Enter to finish editing the cell or press Esc to cancel the current edit.

Once you’ve exited Edit Mode, try pressing Ctrl+Z again.

You should now be able to undo supported changes made to your worksheet.

3. Check Whether a Macro Has Cleared the Undo History

If you’re working with an Excel workbook containing macros, this solution is particularly important.

VBA macros are automated instructions that perform tasks inside Excel. For example, a macro can automatically format cells, remove duplicate entries, delete rows, or update spreadsheet data.

However, running a VBA macro generally clears Excel’s standard Undo history.

This means that if you run a macro and then try to press Ctrl+Z, Excel may not reverse the changes made by that macro.

To check whether your workbook contains macros, look at its file extension.

A macro-enabled Excel workbook usually ends with .xlsm, while a standard Excel workbook generally ends with .xlsx.

If you recently clicked a macro button or ran an automated task, that may explain why Ctrl+Z stopped working.

Unfortunately, Excel doesn’t provide a universal way to restore the standard Undo history after a macro clears it.

If you need to recover your original data, check whether you have a saved backup or an earlier version of the workbook.

4. Disable Excel Add-ins Temporarily

Sometimes, an installed Excel add-in can interfere with normal Excel operations.

Add-ins provide additional features, such as advanced formatting, data analysis, PDF conversion, and productivity tools. However, outdated or incompatible add-ins can occasionally cause unexpected behavior.

You can temporarily disable them to check whether they’re responsible for the problem.

Step 1: Open Excel Options

Open Microsoft Excel and click the File tab in the top-left corner.

Select Options from the left-side menu. This opens the Excel Options window.

Step 2: Open the Add-ins Section

Inside Excel Options, find and click Add-ins.

You’ll see a list of available add-ins and their current status.

Step 3: Manage Excel Add-ins

At the bottom of the window, find the Manage drop-down menu.

Select COM Add-ins and click Go.

Step 4: Disable the Add-ins

You’ll see a list of installed COM add-ins.

Uncheck the selected add-ins and click OK.

Now close Excel, reopen it, and test whether Ctrl+Z works.

If the shortcut starts working, one of your add-ins may be responsible. Enable the add-ins individually to identify the problematic one.

5. Restart Microsoft Excel

Restarting Excel is another simple troubleshooting method worth trying.

Sometimes, Excel may experience temporary glitches that affect keyboard shortcuts, worksheet operations, or other features.

Closing and reopening the application can help clear these temporary problems.

First, save your workbook by pressing Ctrl+S. This is important because restarting Excel without saving could cause you to lose recent changes.

Next, close all open Excel windows.

Wait a few seconds and launch Excel again from the Windows Start menu.

Open your workbook and make a small test change, such as entering text into an empty cell.

Now press Ctrl+Z and check whether Excel reverses the change.

If it works, the issue may have been caused by a temporary application problem.

6. Check Whether Your Keyboard Shortcut Is Working

If the Undo button works but Ctrl+Z doesn’t, you should check your keyboard.

A damaged or unresponsive Ctrl key can prevent keyboard shortcuts from working correctly.

Start by opening another application, such as Notepad.

Type a short sentence, select a few words, and press Ctrl+Z after making an editable change.

If the shortcut doesn’t work in Notepad either, your keyboard may be responsible.

Try pressing the left and right Ctrl keys separately. If you have another keyboard available, connect it and test the shortcut again.

You can also use the Windows On-Screen Keyboard to check whether the Ctrl key is responding.

To open it, press Windows+Ctrl+O.

The On-Screen Keyboard will appear. Use your mouse to select Ctrl and then Z to test the shortcut.

If the shortcut works with another keyboard, consider checking your original keyboard for damaged or stuck keys.

7. Open Excel in Safe Mode

If none of the previous solutions work, try opening Excel in Safe Mode.

Safe Mode starts Excel without loading most add-ins and customizations. This helps you determine whether an external component is causing the problem.

To open Excel in Safe Mode, press Windows+R to open the Run dialog box.

Type the following command:

excel /safe

Press Enter.

Excel should now open in Safe Mode.

Open your workbook and test whether Ctrl+Z works.

If the shortcut works in Safe Mode but fails during normal startup, an add-in, startup setting, or customization may be responsible.

Return to normal Excel mode and disable recently installed add-ins or customizations one at a time.

This is a useful way to narrow down the problem without reinstalling Microsoft Office.

8. Update Microsoft Excel

Using an outdated version of Excel can sometimes cause unexpected application problems.

Microsoft regularly releases Office updates to improve performance, fix bugs, and address compatibility issues.

To check for available updates, open Excel and click File.

Select Account from the left-side menu.

Under Product Information, find the Update Options button.

Click it and select Update Now.

Wait while Microsoft Office checks for and installs available updates.

Once the update process finishes, restart Excel and test the Undo shortcut.

If your Office installation is managed by your workplace or school, update availability may depend on your organization’s settings.

9. Repair Microsoft Office

If Ctrl+Z still doesn’t work, your Microsoft Office installation may have corrupted or missing files.

Windows provides a repair option that can help fix problems with Excel and other Office applications.

Step 1: Open Windows Settings

Press Windows+I to open Settings.

Select Apps, followed by Installed apps.

Step 2: Find Microsoft Office

Scroll through the installed applications and locate your Microsoft 365 or Microsoft Office installation.

Click the three-dot menu next to it.

Step 3: Open the Repair Options

Select Modify.

Depending on your Office installation, Windows may display a User Account Control prompt. Click Yes if asked.

Step 4: Run Quick Repair

Select Quick Repair and click Repair.

Wait for Windows to complete the process.

If the problem continues, repeat these steps and select Online Repair, if available.

Online Repair takes longer and may require an internet connection, but it performs a more comprehensive repair.

Afterward, open Excel and test Ctrl+Z again.

FAQs

1. Why is Ctrl+Z suddenly not working in Excel?

Ctrl+Z may stop working because Excel’s Undo history has been cleared, a macro has been executed, an unsupported operation was performed, or an add-in is interfering with the application.

2. How do I undo changes in Excel without using Ctrl+Z?

You can click the Undo button in Excel’s Quick Access Toolbar. You can also use the mouse to select Undo from the available menu, depending on your Excel version.

3. Why is the Undo button grayed out in Excel?

The Undo button becomes unavailable when Excel has no supported actions in its Undo history. This can happen after running macros or performing certain operations that clear the history.

4. Can I recover changes after Excel’s Undo history is cleared?

Yes, sometimes. You can check Version History if your workbook is stored in OneDrive or SharePoint. You may also be able to recover an earlier copy through Excel’s AutoRecover feature or Windows backups.

5. Does restarting Excel fix the Ctrl+Z problem?

Restarting Excel can fix temporary application glitches. However, it won’t restore Undo history that has already been cleared.

6. Does Ctrl+Z work in Excel Online?

Yes. Excel for the web supports the Undo shortcut for supported actions. However, some operations and features may behave differently from the desktop version.

Summary

The Ctrl+Z not working in Excel problem can happen for several reasons, including cleared Undo history, VBA macros, incompatible add-ins, keyboard issues, or temporary application glitches.

Start by checking whether the Undo button is available. Then make sure you’re not editing a cell, and check whether a macro has cleared the Undo history.

If the problem continues, disable Excel add-ins, restart the application, test your keyboard, and open Excel in Safe Mode. 

Updating or repairing Microsoft Office can also help resolve persistent issues.