Excel Redo Button Greyed Out? Fix It Fast

Errors & fixes · Updated November 22, 2026

If the Excel redo button is greyed out, it means Excel has no action stored in its redo history—either because you haven’t undone anything yet, or the last undo was cleared. The fix is simple: press Ctrl+Y (Windows) or Cmd+Y (Mac) after an undo, or check if you’ve made a new edit since undoing, which clears the redo stack.

Why the Redo Button Goes Grey

Excel’s redo button (the curved arrow pointing right next to the Undo button on the Quick Access Toolbar) only becomes active when there is something to redo. Redo works in reverse of Undo: it reapplies an action you just reversed. The button is greyed out in these situations:

  • You haven’t undone anything yet—redo has nothing to restore.
  • You made a new change after undoing, which permanently clears the redo history.
  • You closed and reopened the workbook—undo and redo history are not saved with the file.
  • You ran a macro or VBA script that modified the workbook; Excel often clears the undo stack after such operations.

How Undo and Redo Actually Work in Excel

Excel keeps a temporary list of your recent actions in memory, called the undo stack. Each time you perform an edit (typing, formatting, deleting rows, etc.), Excel adds that action to the stack. The Undo button (or Ctrl+Z) reverses the most recent action and moves it to a separate redo stack. The Redo button (or Ctrl+Y) takes that action from the redo stack and reapplies it, moving it back to the undo stack. This toggling continues until you perform a brand-new action, which clears the redo stack entirely.

For example, if you type “Hello” in cell A1, then press Ctrl+Z, the text disappears. The redo button now becomes active. Press Ctrl+Y and “Hello” reappears. But if you then type “Goodbye” in cell B2, the redo history is wiped—you can no longer redo the original typing.

How to Fix a Greyed-Out Redo Button

If the button is grey and you expected it to work, try these steps in order:

  1. Perform an undo first. Press Ctrl+Z (or click the Undo button) to reverse your last action. The redo button should light up immediately.
  2. Check the Quick Access Toolbar. Sometimes the redo button is hidden or removed. Right-click the ribbon and choose Customize Quick Access Toolbar. In the dropdown, select All Commands, find Redo, and add it.
  3. Use the keyboard shortcut. Even if the button is greyed out, Ctrl+Y might still work if there is redo history—though if it’s truly grey, there’s nothing to redo.
  4. Reopen the file. If you closed and reopened, undo history is gone. You’ll need to redo manually or use the file’s previous version.

Common Misconceptions About the Redo Button

A frequent misunderstanding is that the redo button can restore changes after you’ve saved the file. Saving does not clear the undo or redo stacks—you can still undo after saving, and redo after undoing. However, closing the workbook or Excel completely clears both stacks. Another misconception: the redo button is the same as “Repeat” (which repeats your last action on a different cell). They are different features. Redo reapplies an undone action; Repeat (also Ctrl+Y in some contexts, but usually Ctrl+D for fill down) duplicates a previous command.

Redo Button on Mac and Excel for the Web

On Excel for Mac, the redo button sits in the same location on the Quick Access Toolbar, and the keyboard shortcut is Cmd+Y. On Excel for the web, the redo button appears in the toolbar at the top, but the keyboard shortcut is the same as Windows: Ctrl+Y (or Cmd+Y on a Mac browser). The web version has a shorter undo/redo history (typically up to 20 actions) compared to desktop versions, which can hold up to 100 actions by default.

How to Increase Undo/Redo History (Advanced)

Excel’s default undo limit is 100 actions, but you can raise it by editing the Windows Registry (Windows only). This is an advanced tweak—back up your registry first. Here’s how:

  1. Close Excel.
  2. Press Win+R, type regedit, and press Enter.
  3. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options (the version number may differ).
  4. Right-click in the right pane, choose New > DWORD (32-bit) Value.
  5. Name it UndoHistory and set its value (decimal) to a number between 1 and 9999.
  6. Restart Excel.

This increases the maximum number of undo steps, which also affects redo capacity. Note that this doesn’t change the greyed-out behavior—it only extends how many actions you can undo/redo before the stack fills.

Frequently Asked Questions

Why is my redo button greyed out after I undo?

If you undo an action and the redo button is still grey, you likely performed a new action after the undo. For instance, you typed something, then pressed Ctrl+Z, then clicked a different cell (which is not an edit and doesn’t clear redo), but if you typed or deleted anything, redo is cleared. Also, some operations like sorting, filtering, or running a macro can clear the redo stack even without a visible edit.

Can I redo after saving the workbook?

Yes, saving does not clear undo/redo history. You can undo and redo after saving, as long as you haven’t closed the workbook. If you close and reopen, the history is lost.

Does the redo button work for formatting changes?

Yes, redo applies to most actions, including formatting (bold, fill color, etc.), inserting/deleting rows, and formula changes. However, some actions like changing the active sheet or scrolling are not recorded in the undo stack.

Why does my redo button disappear from the toolbar?

It might have been removed from the Quick Access Toolbar. Right-click the ribbon, select Customize Quick Access Toolbar, choose All Commands, find Redo, and add it. You can also reset the toolbar to default.

Is there a way to redo after closing Excel?

No, once you close Excel, the undo/redo history is gone. You can try to recover unsaved changes via File > Info > Manage Workbook, but that only restores the last saved version, not the redo history.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.