In Excel for Microsoft 365 on Windows, press Ctrl+Y to redo the last action you undid. On a Mac, use Command+Y; if the shortcut is inconvenient or unavailable, click Redo on the Quick Access Toolbar.
The quick key for redo in Excel
Redo restores an action that you just reversed with Undo. For example, if you delete a value in a cell and press Ctrl+Z, the value returns to its previous state. Press Ctrl+Y afterward and Excel reapplies the deletion. The shortcut works on the active workbook, so check that Excel has focus and that you are not typing inside a cell or another dialog when you use it.
The equivalent shortcuts are:
- Windows:
Ctrl+Y - Mac:
Command+Y - Excel for the web: use the Redo button in the toolbar if the keyboard shortcut conflicts with your browser or does not respond.
Redo is useful when Undo went one step too far, or when you want to compare a workbook before and after a change. It does not mean that Excel can recover every change indefinitely: redo depends on an available undo history, and some operations are not recorded as undoable actions.
What redo does—and what it does not do
Excel keeps a sequence of recent editing actions that it can reverse. Undo moves backward through that sequence; Redo moves forward again through actions that were undone. Think of the two commands as moving along the same short-term editing timeline rather than as separate save or recovery systems.
Suppose you enter a number, apply bold formatting, and change a cell fill color. If you undo the fill and then undo the bold formatting, Excel has backed up two steps. Redo once reapplies bold; redo again reapplies the fill. The order matters: Redo restores the most recently undone step first. It does not selectively reapply an older change while leaving later undone steps out of the sequence.
Redo is also not the same as reopening a previous saved version. It cannot generally bring back edits from an older session once the relevant history is gone. For longer-term recovery, use workbook version history when the file is stored in OneDrive or SharePoint, or use a backup or another saved copy. Those options are separate from the Undo and Redo commands.
Redo versus repeat: Ctrl+Y and F4
A frequent source of confusion is that Ctrl+Y can both redo an undone action and repeat an action, depending on the situation. When there is an action available to redo, Excel uses the shortcut to move forward in the undo history. When there is nothing to redo, Excel may use it to repeat the last action if that action supports repetition.
For example, applying a particular cell format and then selecting another cell may let you repeat the formatting action. Not every operation can be repeated, and behavior depends on what you did and what is selected. In a formula, the function key F4 has a different, especially important use: while editing a cell reference, it cycles through relative and absolute reference forms such as A1, $A$1, A$1, and $A1. So do not press F4 casually while editing a formula if you mean to redo a worksheet action.
In short, use Ctrl+Z to undo, then Ctrl+Y to restore what you just undid. Use repeat behavior only when you intentionally want Excel to apply a supported last action again. If a shortcut seems to repeat formatting instead of restoring a change, check whether there is actually an undone action waiting in the history.
Use the toolbar and redo history
If you prefer not to use a keyboard shortcut, look for the Redo button on Excel’s Quick Access Toolbar. It is commonly positioned above the ribbon, but the toolbar can be customized or displayed differently. Clicking the button performs the same redo as the shortcut. On Mac, the menu bar may also provide the command under Edit, depending on the Excel interface version.
The Undo and Redo controls can be helpful when you want to review several recent actions. In desktop Excel, the arrow beside Undo can show a list of recent actions; choosing an earlier point reverses that action and the subsequent actions in the list. If a Redo drop-down is available, it can move forward through actions that were undone. The number and kinds of entries depend on the workbook’s current history.
To make the Redo button easier to reach in Windows, use the Quick Access Toolbar’s customization options and add the command if it is not visible. This is useful on a compact keyboard, on a device where key combinations are awkward, or when demonstrating a change to someone else. The button also provides a visual clue: if it is disabled, Excel has no available action to redo at that moment.
Why the shortcut may not work
If Ctrl+Y appears to do nothing, the most common explanation is that there is no action available to redo. Redo becomes available only after an undoable action has been undone. Try making a small, harmless edit in a test cell, undoing it with Ctrl+Z, and then using Ctrl+Y. Avoid testing this in valuable data unless you are comfortable restoring the cell afterward.
A second common cause is that a new action replaced the redo path. After you undo something, making a different edit generally means Excel starts a new branch of the editing history, so the former action may no longer be redoable. For instance, undo a fill color and then type a new value: pressing Redo should not be expected to restore the earlier color change. Undo the new entry first only if that is appropriate, and check the toolbar’s available commands.
Other reasons include having focus in a text box, formula bar, dialog, or another application; using a keyboard layout or device that changes how a key combination is entered; or working with an action Excel does not place in its undo history. Running a VBA macro is a notable example: macros can clear Excel’s undo history, and macro changes cannot be reversed with Ctrl+Z unless the macro was specifically designed to provide its own recovery method. Save a copy before running a macro that changes important data.
Also check whether you are using a remote desktop, browser, or keyboard utility that intercepts shortcuts. When in doubt, click Excel’s Redo button rather than repeatedly pressing keys. If the button is disabled too, the issue is likely the available history rather than the keyboard itself.
Redo in Excel for Mac and the web
On Excel for Mac, the standard redo shortcut is Command+Y, while Command+Z undoes. Mac keyboards and application settings can differ, so the menu or toolbar command is a useful alternative if the key combination is intercepted. In particular, check that Excel—not a browser window or another app—has keyboard focus.
Excel for the web runs inside a browser, where browser shortcuts can compete with spreadsheet shortcuts. The toolbar’s Undo and Redo controls are the straightforward fallback. Excel for the web may also present some features and controls differently from the Windows desktop application, so a missing button or different toolbar arrangement does not necessarily mean that redo is unavailable. Use the on-screen command where a keyboard combination behaves unexpectedly.
These shortcuts are about Excel, not every spreadsheet program. Google Sheets and other applications may use different commands or handle browser conflicts differently. If you are switching between programs, look at the application’s Edit menu or toolbar rather than assuming that the same shortcut has the same effect everywhere.
A practical undo-and-redo workflow
For a simple mistake, this sequence is usually enough: make the edit, press Ctrl+Z to undo it, and press Ctrl+Y if you decide the edit was correct after all. Pause after each command and inspect the cells. Excel can undo multiple actions, so repeated shortcuts may move further through your recent edits than you intended.
For example, imagine changing a column’s number format and then deleting a row. If you notice that the row deletion was accidental, undo once and verify that the row is back. If you then realize the format change was also a mistake, undo again. If you only wanted the row back, redo once to reapply the format change while keeping the row restored. This illustrates why the sequence of actions matters and why it is wise to review the sheet after each step.
When many changes are involved, the visible Undo and Redo history can be easier to control than a rapid series of keystrokes. Before making broad changes to a workbook, consider saving a separate copy or using version history if it is available. That is particularly sensible before running macros, deleting sheets, or making edits that affect formulas and linked data, since not every operation can be recovered through redo.
Frequently Asked Questions
What is the redo shortcut in Excel on Windows?
Press Ctrl+Y to redo an action you just undid. If no action is available to redo, Excel may use the shortcut to repeat the last supported action instead.
What is the redo shortcut in Excel on a Mac?
Use Command+Y in Excel for Mac. If the key combination is intercepted or does not work, use the Redo command in Excel’s toolbar or menu.
Is redo the opposite of undo in Excel?
Yes. Undo moves backward through recent undoable actions, and redo moves forward through actions that were undone. A new edit after undo can remove the earlier redo path.
Why does Ctrl+Y repeat formatting instead of redoing?
Excel can use Ctrl+Y to repeat the last supported action when there is no undone action to restore. Undo something first, or use the Redo button to check whether redo history is available.
Can I redo an action after closing and reopening Excel?
Do not rely on redo history after closing a workbook or the application. Redo is a short-term editing feature, not a saved recovery record. Use a backup or version history to recover an earlier saved state when available.
Related
- Open Point List Template for Excel: Setup and Use Guide
- Is Microsoft Excel Open Source? Free Alternatives Explained
- Open Notepad with Excel: Use Both or Import Text Files
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 Set Out of Office in Outlook on the WebTo set an out-of-office message in Outlook on the web, open Settings, find Automatic replies, turn them on,…
- How to Enable Transpose in ExcelExcel does not have a permanent Transpose switch to turn on. To switch rows and columns, copy the…
- Custom Cover Page in Word: Create and Add Your OwnTo add a custom cover page in Word, place a new page at the start of your document,…
- How to Archive Old Emails in Outlook 365 and Find ThemTo archive old emails in Outlook 365, select the messages and choose Archive; Outlook moves them to the…
- How to Insert a Full Line in Word: Borders and ShapesTo insert a full-width horizontal line in Word, put the cursor in the paragraph where the divider should…
- How to Enable the Share Option in Excel for CollaborationTo enable sharing in Microsoft Excel for Microsoft 365 on Windows, save the workbook to OneDrive or SharePoint,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.