In Excel for Microsoft 365 on Windows, press Ctrl+Y to redo the action you just undid. If you mean repeating a command you performed rather than restoring an undone change, F4 can repeat some actions, but it does not work for every command.
The Excel shortcut for redo
When you have used Undo and want to bring the change back, press Ctrl+Y. For example, if you change a cell’s fill color and then press Ctrl+Z, the fill change is undone. Press Ctrl+Y to restore that fill color. You can also click the Redo command on the Quick Access Toolbar, usually shown as a curved arrow pointing to the right.
Redo applies to the most recent action that Excel can restore. If you undo several actions in succession, Excel can redo them in sequence: press Ctrl+Y once for the most recently undone change, then press it again for the next one. The shortcut is useful after an accidental undo, when you want to compare a change with and without its effect, or when you have undone a few steps too many.
If the shortcut does nothing, there may be no available action to redo. The Redo command may appear disabled, or Excel may be in a context where the key combination is being handled differently. The sections below explain what the command restores and how it differs from repeating an action.
Redo, undo, and repeating a command
Undo and redo work as a pair, but redo is not simply a general-purpose replay button. Ctrl+Z reverses an eligible action; Ctrl+Y reapplies an action that was reversed. If you have not undone anything, there may be no change for Redo to restore. This is the key distinction behind the question, “How do I redo my last action?” If you mean reverse an Undo, use Ctrl+Y. If you mean carry out the same operation again on another selection, you are asking to repeat an action.
Excel can repeat certain recent commands, but not all commands are repeatable. On Windows, F4 commonly repeats the last eligible action, such as applying the same formatting to another selected range. Some commands cannot be repeated, and the result depends on what you did most recently and what is selected now. In some contexts, Ctrl+Y may also repeat an eligible command when there is no undone action, but it is safest to use Redo specifically for restoring an undo and to treat repeat behavior as context-dependent.
One important exception is formula editing: while editing a formula, F4 changes a cell reference between relative and absolute forms, such as A1 and $A$1. In that context it is not repeating a formatting command. Press Enter or Esc to finish or leave formula editing before expecting a repeat action.
What happens to the redo history
Excel tracks a sequence of changes that can be undone. When you undo one or more changes, those changes become available to redo. If you then make a new edit instead of redoing, Excel normally starts a new sequence from that point and discards the old redo path. For example, suppose you type a value, apply bold formatting, and undo the formatting. If you now type a different value in another cell, the earlier bold change may no longer be available through Redo. This is why it is worth using Redo before making unrelated changes when you are trying to restore an earlier step.
The history applies to actions Excel supports undoing, not every event that happens while a workbook is open. Some operations, including actions performed by a macro, may not be reversible through the normal Undo command, and running VBA code can clear the standard undo history. If an action cannot be undone, there is no corresponding redo step to restore. For important workbooks, save a copy before running automation or making a large batch of changes that may not be reversible.
Redo is also different from reopening a previous saved version. It works with the current editing history; it does not recover a version from yesterday or restore a closed workbook’s earlier state. For an older saved state, check the workbook’s version history if it is stored in a location that supports it, such as OneDrive or SharePoint. That is a separate recovery feature, not the Redo shortcut.
Practical examples of when to use redo
These examples show how redo behaves in ordinary worksheet work:
- Undoing an accidental deletion: If you delete a cell’s contents and immediately press Ctrl+Z, then decide the deletion was intended, press Ctrl+Y. Excel restores the deletion as the current action.
- Checking a formatting change: Apply a border, undo it to inspect the sheet without it, then redo to put it back. This is useful when comparing appearance, provided you do not make another edit that replaces the redo path.
- Recovering from too many undos: If you press Undo repeatedly and go one step further back than intended, press Redo once. Each press advances one available action.
- Applying formatting elsewhere: If you bold one range and want to bold another, select the second range and try F4. This is repeating an eligible formatting action, not redoing an undone one, so it may not work for other kinds of commands.
Be cautious when selecting a different range before using a repeat command: a repeat operation may affect the current selection. Redo, by contrast, restores the undone step in the history rather than asking you to choose a new destination. If the outcome is not what you expected, stop and inspect the worksheet before making further changes.
Using the Redo button instead of the keyboard
The toolbar is a useful alternative when you cannot remember the shortcut, are using a touch device, or the keyboard shortcut is intercepted. In desktop Excel, look for the curved-arrow Redo command on the Quick Access Toolbar, typically near the upper-left area of the window. If it is unavailable or appears dimmed, Excel has no redoable action at that moment. Use the toolbar command when you want a visual check of whether Redo is available, or when working with a keyboard layout that makes the shortcut inconvenient.
The Undo and Redo controls can also show a list of recent actions in supported desktop versions. A list can help you understand what a sequence of undos will affect, rather than guessing based on the current cell. Selecting an earlier item in an Undo list generally undoes that item and the actions after it, so review the labels before choosing. The Redo list becomes relevant after you have undone actions and can show which changes are available to restore.
On Excel for the web, the ribbon’s Undo and Redo buttons are a straightforward option, especially if a browser or operating system uses a key combination for another purpose. The exact layout can vary with the window size, but the commands remain the same in principle: Undo reverses a supported edit, and Redo restores an edit that was undone.
Windows, Mac, and Excel for the web
This answer is for Excel for Microsoft 365 on Windows. On Excel for Mac, use Command+Y for Redo. The Mac keyboard also uses Command+Z for Undo. Since Mac keyboards and system settings differ, the ribbon’s Redo button is a reliable alternative if the shortcut does not behave as expected. Function-key behavior on a Mac may require the Fn key or a change to keyboard settings, so do not assume that F4 behaves exactly as it does on Windows.
Excel for the web also provides Undo and Redo controls. Keyboard shortcuts can depend on the browser and operating system, so use the on-screen controls if a shortcut appears to trigger a browser command or does nothing. The Windows shortcut remains Ctrl+Y in the desktop version; for Mac desktop Excel, the equivalent is Command+Y. Neither shortcut restores changes from a different saved session.
Why Ctrl+Y may not work
A few common causes explain why pressing Ctrl+Y may appear ineffective:
- There is nothing to redo. Redo usually becomes available after an Undo. Check whether the Redo toolbar button is enabled.
- A new edit replaced the redo path. After undoing, another change can discard the earlier redoable sequence. Undo the new change only if appropriate; do not expect that to recover a discarded action.
- The action was not undoable. Some operations, including macro-driven changes, do not participate normally in Excel’s undo history.
- You are in a different application or context. A browser, remote desktop, or another program may capture the shortcut. Click back into the workbook and try the ribbon command.
- You meant repeat rather than redo. If you want to apply the same eligible command to a new selection, try F4 on Windows, while remembering that it has other uses and does not repeat every operation.
If the worksheet’s current state is important, avoid experimenting with repeated shortcuts on live data. Save the workbook first, or use a copy. For a small, easily checked change, inspect the affected cells after each undo or redo; for a complex workbook, compare the relevant formulas, values, and formatting rather than relying on the keypress alone.
Frequently Asked Questions
What is the redo shortcut in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Y. On Excel for Mac, press Command+Y. You can also click the Redo button.
Is Ctrl+Y the same as Ctrl+Z?
No. Ctrl+Z undoes an eligible action. Ctrl+Y redoes an action you have undone, restoring it.
How do I repeat the last action in Excel?
On Windows, F4 repeats some eligible actions, such as certain formatting changes. It is context-sensitive, and while editing a formula it changes cell references instead. Repeating an action is not the same as redoing an undo.
Why is Redo greyed out in Excel?
It is usually disabled because there is no action available to redo. This can happen before you have undone anything, after a new edit replaces the redo sequence, or when the earlier operation was not recorded as undoable.
Can I redo a change after closing the workbook?
Redo is not a way to recover an earlier state after the editing history is gone. If you need an older saved version, check version history in the workbook’s storage service, when available, or use a backup copy.
Does redo work after running a macro?
Not reliably. Macro actions generally cannot be reversed with the normal Undo command, and running VBA can clear Excel’s undo history. Save a separate copy before running a macro if you may need to restore the original workbook.
Related
- Excel Print Zoom to Fit Page: Setup and Common Fixes
- Excel Print: Keep Row and Column Headers on Every Page
- Excel Print Header on Each Page: Repeat Rows in Print
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Mail Merge in Word: A Complete Step-by-Step GuideTo mail merge in Word, prepare a recipient list—usually an Excel workbook—then use the Mailings tab to connect…
- Insert Key in Excel: What It Does and How to Use It SafelyTo use the Insert key in Excel for Microsoft 365 on Windows, open File > Options > Advanced,…
- Count Excel Without Blanks: COUNTA and Other MethodsTo count cells that are not blank in Excel, use =COUNTA(A2:A20), replacing A2:A20 with your range. COUNTA counts…
- Best Way to Export Outlook Contacts as CSV or PSTFor most people, the best way to export Outlook contacts is to save them as a CSV file:…
- Excel Data Validation: Lists, Rules, and Common FixesIn Microsoft Excel for Microsoft 365 on Windows, data validation controls what users can enter in selected cells.…
- How to Delete a Full Page in Word: Step-by-StepTo delete a full page in Word, click anywhere on that page, open Go To, enter \page, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.