In Excel for Microsoft 365 on Windows, press Ctrl+Y to redo an action you just undid. On a Mac, press Command+Y; you can also click Redo on the Quick Access Toolbar. Redo is available only while Excel still has the undone action in its redo history.
The Excel redo shortcut on Windows
Use Ctrl+Y after pressing Ctrl+Z or choosing Undo. Each press redoes one action, so if you undid several changes, press Ctrl+Y repeatedly to restore them in sequence. For example, if you removed a cell’s fill color and then deleted a row, undoing twice reverses the row deletion first and the formatting change second. Redoing twice reapplies the formatting change first, then deletes the row again.
The shortcut works in the Excel desktop app for Microsoft 365 on Windows. You do not need to select the affected cell before redoing an action. Excel applies the redo to the action history, rather than to whatever cell happens to be active now. This is useful when you have moved around the sheet after undoing and want to restore the previous edit.
How to redo with the toolbar
If you prefer not to use a keyboard shortcut, use the Redo button on the Quick Access Toolbar. It is typically shown as a curved arrow pointing forward, near the top of the Excel window. Click it once to redo one action. If Excel has no redoable action, the button may be disabled or absent from the visible toolbar.
The toolbar is also useful when you are unsure which keyboard shortcut applies, or when a keyboard layout or remote desktop setup makes a key combination awkward. To add Redo if it is not shown in desktop Excel for Windows:
- Open File > Options.
- Choose Quick Access Toolbar.
- In the command list, select Redo, then choose Add.
- Select OK to save the change.
Once it is on the toolbar, the button is available across workbooks in the app. The Undo and Redo controls may also have small menus beside them. Those menus let you choose a point in the recent action list and undo or redo several consecutive actions together, rather than clicking repeatedly. The exact controls can look different if you have customized the toolbar or use a different Excel layout.
What Excel means by redo
Undo and redo operate on Excel’s recent action history. Undo reverses an eligible action; redo reapplies an action that was reversed. Redo is therefore not a general command to repeat anything you did earlier in the workbook. It restores a change from the current undo history, such as typing a value, applying formatting, or deleting a row, provided Excel still has that action available.
Redo follows the order of the undo history. If you undo a series of changes, Excel makes them available to redo in the opposite order from the way they were originally performed. Pressing Ctrl+Y once restores the most recently undone change. Pressing it again restores the next one. This sequence can help you recover a change you reversed by mistake without repeating the whole task manually.
That history is temporary, not a permanent log of every edit ever made. It is separate from workbook version history and is not a substitute for saving a copy. Closing a workbook ends its ordinary undo and redo history, so reopening it generally will not let you redo edits from the previous session using Ctrl+Y.
Why redo may be unavailable
If Ctrl+Y does nothing, or the Redo button is gray, Excel may have no action waiting to be restored. This commonly happens in any of these situations:
- You have not undone anything. Redo becomes relevant after an undo; it is not always a repeat-last-command shortcut.
- You made a new change after undoing. A new workbook edit or command usually replaces the pending redo sequence. For instance, undo a cell entry and then type a different value: Excel will generally discard the old entry from the redo chain.
- You closed and reopened the workbook. The session’s ordinary action history is not retained as a redo list across closing the workbook.
- A command or macro disrupted the history. Some operations cannot be undone, and running a VBA macro typically clears Excel’s undo history. Ctrl+Z cannot reverse a macro run.
- The shortcut is being handled elsewhere. This can occur with browser-based Excel, remote desktop software, or another app that captures the keystroke. Try the Redo button in Excel’s interface.
When the history is gone, repeatedly pressing Ctrl+Y will not recover the missing edit. If the workbook is stored on OneDrive or SharePoint and version history is available, you may be able to inspect or restore an earlier saved version through File > Info > Version History in desktop Excel. Check the version and its contents carefully before restoring it, because version history is a separate recovery feature and may replace newer workbook content.
Redo versus repeating the last action
Redo is often confused with repeating an action. In Excel for Windows, Ctrl+Y redoes an available undone action. F4 can repeat the last eligible action in some situations, but it is not a reliable replacement for redo. For example, F4 may repeat a formatting operation, whereas Ctrl+Y restores an action that was undone.
F4 also has a different job while you are editing a formula: it cycles through relative and absolute cell references. If you are typing a formula such as one containing A1, pressing F4 can change the reference style instead of repeating a worksheet command. What F4 does depends on the current context, so use Ctrl+Y when your goal is specifically to reverse an Undo.
A practical distinction is: choose Redo to bring back the change you just undid; consider F4 only when you deliberately want Excel to repeat a compatible recent action. Neither shortcut can restore an action that has been removed from the current history.
Using redo on Mac and in Excel for the web
In Excel for Microsoft 365 on Mac, the redo shortcut is Command+Y. You can also use the Redo control in the toolbar. Mac keyboards and customized shortcuts can vary, so the toolbar is a useful fallback if the key combination is intercepted or does not behave as expected.
In Excel for the web, use the Redo button in the Excel interface if the keyboard shortcut is inconvenient or a browser captures it. Browser and operating-system shortcut handling can affect which keys reach a web app. The toolbar avoids that uncertainty and makes it clear whether Excel currently has an action available to redo. Regardless of platform, the basic rule is the same: redo restores an undone action from the active history; it does not retrieve an edit from a closed session.
Examples of when Ctrl+Y helps
Redo is especially useful when Undo reverses more than you intended. Suppose you apply bold formatting to a heading, enter a value in a nearby cell, and then undo twice while trying to remove the value. If the second undo also removes the heading’s bold formatting, Ctrl+Y can restore the most recently undone action, and another press can restore the preceding one, as long as you have not made a new edit that replaces the redo history.
It can also help after testing a change. You might apply a number format, undo it to compare the original display, and then decide the new format was clearer after all. Press Ctrl+Y to reapply it rather than reopening the formatting controls. Redo applies the prior action as Excel recorded it; it does not ask you to choose new formatting options.
Use extra care with large changes. Before redoing a deletion or a multi-step operation, look at the worksheet and consider whether the action is the one you mean to restore. If you are unsure, the Redo menu can show the available actions and help you identify how many steps you are about to reapply. For important workbooks, save a separate copy before making risky changes. The undo history is convenient, but it should not be treated as a backup.
Frequently Asked Questions
What is the redo shortcut in Excel for Windows?
Press Ctrl+Y to redo an action you previously undid. You can also click Redo on the Quick Access Toolbar.
What is the redo shortcut in Excel for Mac?
In Excel for Microsoft 365 on Mac, press Command+Y. If the shortcut is intercepted or unavailable, use the Redo button in the toolbar.
Why is Ctrl+Y not working in Excel?
There may be no action left to redo, or a newer edit may have cleared the redo sequence. The workbook may also have been closed, or another app or browser may be capturing the shortcut. Check whether the Redo button is enabled.
Does Ctrl+Y repeat the last action?
In Excel, Ctrl+Y is principally the redo shortcut, restoring an undone action. F4 can repeat some eligible actions, but its behavior depends on context and it also changes cell-reference styles while you edit a formula.
Can I redo an edit after closing and reopening the workbook?
Usually not with Ctrl+Y, because the ordinary undo and redo history does not persist after the workbook is closed. For a cloud-stored workbook, check Version History if it is available, or use a backup copy.
Can Ctrl+Y undo a macro?
No. Running a VBA macro typically clears the regular undo history, and Ctrl+Z or Ctrl+Y cannot reverse the macro’s effects. Save a copy before running a macro if you may need to recover the prior workbook state.
Related
- Randomize Names in Excel Without Repeats: Easy Methods
- Randomize Groups in Excel: A Practical Guide
- Randomize in Excel Without Repeating Numbers: 3 Ways
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Calculate the Length of Time Between Two DatesTo find the elapsed number of days between two dates in Excel, subtract the earlier date from the…
- Excel Justify Shortcut: How to Align Text in CellsExcel does not have a dedicated default keyboard shortcut that applies Justify alignment directly to a selected cell.…
- Excel Cleanup Taking Too Long? Make Cleanup FasterIf Excel cleanup is taking too long, stop fixing cells one by one: identify the repeated problem, apply…
- Styles in Word: How They Work and How to Use Them WellStyles in Microsoft Word are named sets of formatting that you can apply to text, paragraphs, tables, or…
- How to Insert a Check Box in Word for Lists or FormsTo add a clickable check box in the Word desktop app, open the Developer tab and select Check…
- Excel Data Entry Form: Add an Image Box Step by StepTo add an image box to an Excel data entry form, place a picture in a worksheet cell…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.