To redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y after you have undone something. You can also click the Redo button on the Quick Access Toolbar. On a Mac, press Command+Y; in Excel for the web, use the toolbar or the keyboard shortcut supported by your device.
How to redo an action in Excel
Redo reapplies an action that you just reversed with Undo. For example, if you accidentally delete a value and press Ctrl+Z to bring it back, Ctrl+Y reapplies the deletion. It is useful when you undo too far, change your mind about an edit, or want to compare a workbook before and after a recent change.
On Windows, use either of these methods:
- Press Ctrl+Y to redo the most recently undone action.
- Click the Redo arrow near the top of the Excel window, usually on the Quick Access Toolbar.
- If the toolbar shows a drop-down arrow beside Redo, open it to see available undone actions. Choosing an item can redo that action and the later actions in the sequence.
On a Mac, the standard redo shortcut is Command+Y. If you cannot find the button, look on the Quick Access Toolbar; its position and appearance can vary with the Excel layout. In Excel for the web, the Undo and Redo controls are in the toolbar above the worksheet. These buttons are a useful alternative if a browser or keyboard setting intercepts a shortcut.
What Excel means by redo
Excel tracks many recent actions in an undo-and-redo sequence. Undo moves backward through that sequence; redo moves forward again through actions you have undone. Redo does not mean repeat any action you choose from the past. It is available only for actions that are currently on the redo sequence.
Imagine that you enter a number in a cell, then make the cell bold. If you undo once, Excel removes the bold formatting. Undo a second time and it reverses the entry. Redo once restores the entry; redo again restores the bold formatting. The order matters because Excel reverses actions from newest to oldest and reapplies them from oldest to newest.
When Excel has nothing to redo, the Redo button is unavailable or appears dimmed. Pressing Ctrl+Y in that situation may repeat an eligible previous command rather than restore an undone action. That behavior can make the shortcut seem inconsistent, but redo and repeat are different jobs: redo follows the undo sequence, while repeat performs a recent action again.
A simple example: undo and then redo
Suppose cell B2 contains 40. You replace it with 45, press Enter, and then realize the change was a mistake. Press Ctrl+Z and Excel restores 40. If you decide that 45 was correct after all, press Ctrl+Y and Excel restores 45. The shortcut works on the most recent reversible change, so make sure the worksheet is active and that you have actually undone the edit.
You can try the same sequence with a harmless formatting change. Select a cell, choose Home > Bold, undo with Ctrl+Z, and redo with Ctrl+Y. This illustrates that redo applies more than cell contents: it can restore formatting and many other recent worksheet actions as well. The particular actions available depend on what you have done and on whether Excel still retains them in its history.
One small distinction matters while entering data. If you are still editing inside a cell and have not confirmed the entry, press Esc to cancel that in-progress edit. Once you have committed the value with Enter or by moving to another cell, Ctrl+Z can undo it, and Ctrl+Y can redo it afterward.
Which actions can be redone?
Many everyday worksheet changes can be undone and redone, including entering or clearing cell contents, applying formatting, and making common structural changes. For instance, if you add a border and then undo it, redo can restore the border. If you undo deleting a row, redo can delete that row again.
However, Excel does not promise that every operation will be reversible. Some commands, interactions with external data, and actions performed by add-ins or automation may not behave like ordinary cell edits. In particular, running a VBA macro clears Excel’s regular undo history, and macro actions generally cannot be reversed with Ctrl+Z. Save a copy before running an unfamiliar macro or other operation that could make broad changes.
Redo is also not a substitute for version history or a backup. It only moves forward through the available recent undo sequence in the current editing context. It cannot recover an edit from a closed workbook session or restore an older saved version by itself. For an important file, use the appropriate version-history or backup option rather than relying on the redo button as a long-term recovery tool.
Why Redo may be unavailable
If Redo is dimmed, Excel currently has no action in its redo sequence. The most common cause is that no action has been undone in the current sequence. Another common cause is making a new change after undoing: a new edit generally starts a different path, so the previously undone actions are no longer available to redo.
- Check whether you used Undo: Redo normally becomes available after an undoable action has been reversed.
- Look for a new edit after Undo: Typing, formatting, or another change can replace the redo path.
- Check the active window: Click in the workbook before using the shortcut, especially if another app or dialog box has focus.
- Check the button state: A dimmed Redo control indicates there is no current action to reapply.
- Consider macros or special commands: Some operations clear or bypass the ordinary undo sequence.
If Ctrl+Y seems to perform an action instead of restoring an undone one, check whether anything is actually available to redo. Excel can use Ctrl+Y to repeat certain eligible actions when no redo is pending. Avoid repeatedly pressing it if the worksheet is changing in an unexpected way; use Ctrl+Z to reverse the latest change if that action is undoable, or close without saving only when you are sure you do not need other unsaved work.
Redo versus Undo and Repeat
Undo reverses the most recent supported action. On Windows, the shortcut is Ctrl+Z; on a Mac, it is Command+Z. Redo reapplies an action that was undone, using Ctrl+Y on Windows and Command+Y on a Mac. The two commands are related, but redo needs an available undone action.
Repeat means carrying out a previous action again, such as applying the same formatting to another selection. In desktop Excel for Windows, F4 can repeat many eligible actions; Ctrl+Y may also repeat an action when there is nothing to redo. Neither method lets you select any old action from a complete workbook history. Whether an action can be repeated depends on the command, and keyboard behavior can differ by device and context.
For example, if you bold one heading and then select another cell, using a repeat command may apply bold formatting again. That is not the same as redoing an undone bold action. If you are unsure which command applies, check the Redo button’s enabled state or use its drop-down list rather than relying on a shortcut that may repeat.
Using Redo on Windows, Mac, and the web
This guidance is for Excel for Microsoft 365 on Windows. Ctrl+Y is the standard redo shortcut there, and the Undo and Redo icons are commonly available on the Quick Access Toolbar above the worksheet. If you use those buttons often, you can customize that toolbar from Excel’s options and add commands that are not currently visible.
In Excel for Microsoft 365 on Mac, use Command+Y for redo and Command+Z for undo. Toolbar placement and customization screens differ from Windows, so the button may not be in the same spot. If the shortcut does not appear to work, make sure Excel has focus and use the visible Redo control instead.
Excel for the web has Undo and Redo controls in its toolbar. Keyboard shortcuts can depend on the operating system, browser, and current focus, so the toolbar is a straightforward choice when a key combination is intercepted. The web app’s available actions and behavior can also differ from desktop Excel; do not assume every desktop command or undoable action is available in the browser version.
A careful workflow for correcting mistakes
Undo and redo are convenient for recent edits, but it helps to use them deliberately in a complex workbook. A short sequence of checks reduces the chance that a second action will remove the redo path you meant to keep:
- Identify the change you want to reverse and confirm the worksheet is active.
- Press Ctrl+Z on Windows or Command+Z on Mac once, then inspect the affected cells.
- If Excel reversed the intended change, use Ctrl+Y or Command+Y to put it back.
- If you need to examine several steps, use the toolbar’s Undo or Redo drop-down when available, and check the result after applying a group of actions.
- For changes you cannot easily reconstruct, save a separate copy or use workbook version history before making further edits.
Do not treat Undo as a reliable way to preview a complex operation after making unrelated changes. If you undo several steps and then type something new, you may lose the ability to redo the earlier steps. For a risky edit, make a copy of the file or duplicate the relevant worksheet before changing it. That gives you a dependable comparison point even if the undo sequence is no longer available.
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. You can also click the Redo button in the toolbar.
Can I redo more than one action in Excel?
Yes. Press the redo shortcut repeatedly or use the Redo drop-down, when available, to reapply multiple undone actions in sequence. Excel reapplies them in their original order.
Why is the Redo button greyed out?
There may be nothing to redo, or a new action after Undo may have replaced the redo sequence. Some commands and macros can also clear the regular undo history.
Can I redo after closing and reopening a workbook?
Do not rely on it. Redo is for the current undo sequence, not a permanent record of changes across closed sessions. Use a backup or version history to recover an earlier saved state.
Is Ctrl+Y the same as repeating an action?
Not always. When an undone action is available, Ctrl+Y redoes it. In some contexts, Excel can use Ctrl+Y to repeat an eligible action if there is nothing to redo.
Related
- Conditional Formatting in Excel for a Specific Date
- Excel Conditional Formatting Icons: How to Use Them
- Excel Conditional Formatting Icon Sets: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Duplicates in Power Query: A Practical GuideYes. In Excel for Microsoft 365 on Windows, open the query in Power Query Editor, select the column…
- Excel Not Responding When Printing? Causes and FixesIf Excel stops responding when you print, first save the workbook if possible, then check whether the problem…
- Open Excel Solver Add-in: Enable and Use ItTo open Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in at File > Options…
- Downloadable Budget Spreadsheet: Find and Use a TemplateYes. You can download a budget spreadsheet template from Excel’s template gallery or Microsoft Create, then save a…
- Remove Formatting in Microsoft Word: Step-by-StepTo remove formatting in Microsoft Word, select the text, then choose Home > Clear All Formatting in the…
- Add a Plus Sign to Hide Columns in Excel with GroupingTo add a plus sign that can reopen hidden columns, select the columns, choose Data > Group, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.