Excel Redo Shortcut: How to Restore an Undone Action

In Excel for Microsoft 365 on Windows, press Ctrl+Y to redo an action you just undid. On a Mac, press Command+Y; if a shortcut is unavailable or intercepted, use the Redo button on the Quick Access Toolbar.

How to redo an action in Excel

Redo reverses your most recent undo. For example, if you delete a value and then press Ctrl+Z to bring it back, Ctrl+Y deletes it again. To try it in a workbook, make a small change, such as entering a test value in an empty cell, press Ctrl+Z, and then press Ctrl+Y. The value should disappear, reappear, and disappear again as you undo and redo.

Use the shortcut after you have finished entering or editing a cell. If Excel is currently showing a text cursor inside a cell or the formula bar, keyboard input may be handled as part of that edit rather than as a worksheet command. Press Enter or Escape to leave the edit first, then use Ctrl+Y.

You can also click Redo on the Quick Access Toolbar, usually shown near the top of the Excel window. Its position can vary depending on how the toolbar is configured. After an undo, the Redo command becomes available; before an undo, it may be disabled. The toolbar is useful if you forget the shortcut, are using a touch device, or want to see whether Excel has an action ready to restore.

What redo does—and how its history works

Excel keeps a temporary sequence of recent actions that it can undo. When you undo one or more actions, those actions become available to redo, generally in the reverse order from which they were performed. If you entered a number, changed a fill color, and then undid both actions, the most recent change—the color—would be the first one restored. Pressing Ctrl+Y again could restore the earlier entry, provided the redo sequence remains available.

Redo is not the same as reopening an older version of a file. It operates on the current undo and redo history, not on a permanent record of every change. It is also not a substitute for saving a workbook or making a backup. Once the relevant action is no longer in Excel’s current history, Ctrl+Y cannot retrieve it.

A new action after undoing usually replaces the redo path. Suppose you change A1, change B1, and undo twice. If you then type a new value in C1, Excel starts a different sequence from that point. The earlier undone changes may no longer be redoable. This is why it is worth using redo immediately when you realize you undid too much, rather than making unrelated edits first.

Redo versus repeat the last action

Ctrl+Y has a closely related use in Excel: it can repeat the last action when there is no undone action waiting to be restored and the action supports repetition. The exact behavior depends on what you did. This overlap can make the shortcut seem inconsistent: after an undo it restores the undone step; in other circumstances it may apply a previous command again.

For example, Excel can repeat some formatting or structural operations, such as applying a similar change to another selection. Repetition is not universal: some commands cannot be repeated, and the result can depend on the current selection. Treat Ctrl+Y as redo when you have just used Ctrl+Z and want that step back. If you are using it to repeat a command, check the affected cells afterward.

On Windows, F4 can also repeat the last action in supported situations. It is not a perfect substitute for Ctrl+Y: F4 has other uses, including changing cell references while editing a formula, and some keyboards require the Fn key to send an F4 keystroke. For restoring an undone worksheet action, Ctrl+Y is the clearest choice.

Examples of when redo is useful

Redo is especially helpful when Ctrl+Z removes more than you intended. Imagine you correct a formula, apply a number format, and then press Ctrl+Z repeatedly while trying to reverse only the format. If the formula correction is also undone, Ctrl+Y can restore that correction. You can then stop at the point where the workbook is right again.

It also helps when checking a change before committing to it. You might apply a border to a table, undo it to compare the original appearance, and redo it if the border was preferable. Likewise, after undoing a mistaken cell deletion, redo can return the sheet to the state immediately after deletion if that is what you decide you need.

For formula edits, redo restores the edit as an action; it does not guarantee a particular displayed result if the formula depends on values that have since changed or on recalculation. Review the formula bar and the resulting cell value. A quick visual check matters when undoing and redoing several steps in a complex model.

Why Ctrl+Y may not work

If nothing seems to happen, first check whether there is actually an undone action available. Redo is normally disabled until you undo something. Click the Undo command once if appropriate, then try Ctrl+Y. Avoid pressing Undo merely to enable Redo if you are unsure what it will reverse; it changes the workbook.

A different edit replaced the redo path. After undoing, a new worksheet action can discard the steps you expected to redo.
You are still editing a cell. Finish or cancel the cell edit, then try the shortcut again.
The active application or control has focus. A dialog, add-in, browser, or another program may receive the keystroke instead of the worksheet.
The action is not available in Excel’s history. Some operations cannot be undone, and certain actions—most notably running a VBA macro—can clear the undo history.
The keyboard layout or device changes the key behavior. On laptops, function keys may require Fn; on a Mac, use Command rather than Ctrl for the usual Excel redo shortcut.

Excel’s ordinary undo history is temporary, not a version history that you can browse indefinitely. Closing a workbook or Excel and later reopening it should not be treated as a way to preserve redo steps. If you need a lasting recovery point, save a separate copy or use version history where it is available through your storage service; that is a different recovery mechanism from Ctrl+Y.

Windows, Mac, and Excel for the web

In the Windows desktop version of Microsoft Excel for Microsoft 365, the standard redo shortcut is Ctrl+Y. The corresponding standard shortcut in Excel for Mac is Command+Y. If that does not work in a particular setup, use the Redo control in the toolbar rather than assuming that Ctrl+Y has the same meaning on a Mac.

Excel for the web also supports undo and redo through its toolbar, and keyboard shortcuts can depend on the browser and keyboard environment. On a Windows keyboard, try Ctrl+Y; if the browser or another control handles it, click the visible Redo command in Excel. On a Mac, try Command+Y or use the toolbar. The toolbar is the dependable alternative when browser shortcuts conflict.

The Redo button may not be in exactly the same place in every edition or customized layout. Look for the curved-arrow Redo control near Undo, often on the Quick Access Toolbar or the web app’s top toolbar. If it is not visible, check Excel’s toolbar customization options or use the keyboard shortcut for your platform.

Safer ways to manage changes

Undo and redo are convenient for recent edits, but they are not a replacement for deliberate file protection. Before running a macro, performing a large transformation, or making a change that would be difficult to reconstruct, save a copy of the workbook. Macros cannot be undone with Ctrl+Z, and a macro run can remove the ordinary undo history.

For routine work, make a habit of checking the status of the Undo and Redo controls before clicking them. If you need to step back several actions, Excel’s Undo control may offer a list of recent actions from which to choose, depending on the desktop interface. Redo proceeds through the undone actions in order; it is not generally a way to select an arbitrary old change while skipping all the steps before it.

When a mistake affects an important workbook, pause before adding more edits. If the action is still available, undo it; if you undid too much, redo promptly. If the history has been lost, consider whether a saved copy, cloud version history, or a source-data reimport can restore the needed information. Those options restore a broader file state and may also replace legitimate edits made since the recovery point, so compare carefully.

Frequently Asked Questions

What is the redo shortcut in Excel?

In Excel for Microsoft 365 on Windows, press Ctrl+Y. On a Mac, press Command+Y. Redo restores an action that you have just undone, as long as that action remains in Excel’s current history.

What is the opposite of Ctrl+Z in Excel?

Ctrl+Y is the usual opposite of Ctrl+Z on Windows: Ctrl+Z undoes the latest action, and Ctrl+Y redoes an action you undid. On a Mac, the usual pair is Command+Z and Command+Y.

Why is Redo greyed out in Excel?

Redo is usually unavailable because you have not undone an action, or because a later edit replaced the redo sequence. Some operations also cannot be undone or can clear Excel’s undo history. The toolbar’s disabled Redo control indicates that Excel has no available step to restore.

Can I redo after making a new change?

Often, no. Making a new worksheet change after undoing usually creates a new action path and removes the earlier redo steps. If you realize you undid too much, redo before editing elsewhere.

Does Ctrl+Y repeat the last action in Excel?

It can. When there is no undone action to restore, Ctrl+Y may repeat the last command if that command supports repetition. That is separate from its redo role after Ctrl+Z, and repeated actions can have different effects depending on the selected cells.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.