To redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y after undoing it with Ctrl+Z. You can also click the Redo arrow on the Quick Access Toolbar; redo is available only while Excel still has an undone action to restore.
Use the keyboard shortcut
Ctrl+Y is the quickest way to redo an action in the Windows desktop version of Excel. For example, if you delete a value in a cell and immediately press Ctrl+Z, Excel restores the value. Press Ctrl+Y and Excel applies the deletion again. The shortcut works on a sequence of undoable actions, so you can often press it more than once to redo several changes in order.
Excel usually shows the Redo command as available after you undo something. If the command appears dimmed, or clicking it does nothing, there may be no action left to redo. The shortcut is not a general command to retrieve old data: it replays an action from Excel’s current undo history.
- Undo: Ctrl+Z reverses the latest undoable action.
- Redo: Ctrl+Y restores an action that you just undid.
Redo an action step by step
Use this sequence when you have undone more than intended:
- Pause before making another edit. A new action can replace the redo path.
- Press Ctrl+Y once, or click the Redo arrow near the upper-left corner of the Excel window.
- Check the worksheet to confirm that the expected change returned.
- Repeat the shortcut if you undid several changes and want to restore more than one.
Suppose you entered a heading, changed its font to bold, and then used Ctrl+Z twice. The heading entry and the formatting change have both been undone. Pressing Ctrl+Y once restores the first action in the redo sequence; pressing it again restores the next. Check the sheet after each press, especially if the actions affected different cells.
How undo and redo work
Undo and redo are two sides of a temporary action history. Undo moves backward through recent actions; redo moves forward through actions that have been undone. Redo does not mean “repeat whatever I did last week,” and it is not the same as restoring an earlier saved version of a workbook.
After you undo an action, Excel keeps it available to redo until something changes the current history. If you undo a format change and then type a new value, Excel generally treats the new edit as a new branch of work. The previously undone action may no longer be available through Ctrl+Y. This is why it is best to redo immediately rather than continue editing and expect to recover an older action later.
Excel groups some related edits together, so one press may not always correspond to one keystroke or one cell. For example, an operation that changes a selected range can be treated as one action. The exact grouping depends on what you did, so use the worksheet and the Undo or Redo labels as a guide.
Use the Redo button and action list
The Redo button is on the Quick Access Toolbar, normally near the top-left of the Excel window. It is useful if you prefer a mouse or if a keyboard shortcut is intercepted by another program. Click the curved arrow pointing forward when it is enabled. If you cannot see the toolbar, its position or contents may have been customized; the Excel Options settings let you adjust the Quick Access Toolbar.
The small menu beside the Undo button can show recent actions that are available to undo. Selecting an item in that list can undo that action and later actions in the sequence, so read the labels before choosing. Afterward, Excel may make the corresponding actions available to redo. The exact buttons shown can vary with the toolbar layout and Excel window size.
If the toolbar button is missing, use the keyboard shortcut instead. You can also customize the Quick Access Toolbar from its toolbar menu or through File > Options > Quick Access Toolbar on Windows, then add the relevant command. The Redo command is separate from the Undo command, even though they sit beside one another.
Shortcuts on Mac and in Excel for the web
On Excel for Microsoft 365 for Mac, use Command+Y to redo and Command+Z to undo. Mac keyboards use the Command key where Windows instructions use Ctrl. The Redo button on the Quick Access Toolbar is also an option on Mac.
In Excel for the web, Ctrl+Y is the standard Windows redo shortcut, and the toolbar’s Redo control is an alternative. When using a Mac browser, try Command+Y or use the on-screen control. Browser shortcuts and keyboard settings can affect which app receives a keystroke, so the toolbar is the dependable fallback if the shortcut does not reach Excel.
These instructions concern Excel, not every spreadsheet application. Shortcuts can differ in Google Sheets or in other programs, even when the same workbook file is open. If you are working in a browser, check that the active tab is the Excel workbook before using the shortcut.
Why redo may be unavailable
The most common reason is that there is nothing in the current history to redo. Redo becomes relevant after an undo; if you have not undone an action, the button may be disabled. It can also become unavailable after a new edit replaces the undone sequence. For instance, undoing a cell entry and then typing a different value usually means Ctrl+Y will not bring back the original entry.
Some Excel operations cannot be undone in the same way as ordinary cell edits, and certain actions, including running a VBA macro, can clear the undo history. If the expected change came from a macro or another operation that cleared history, Ctrl+Y cannot reconstruct it. Avoid assuming that every command has a matching undo or redo.
Also check whether the action happened in the workbook you currently have selected. If you switched workbooks or windows, you may be looking at a different sheet from the one where the edit occurred. Excel’s history is not a substitute for a saved copy, a version history entry, or a backup.
Redo versus repeat the last action
Redo restores an action that was undone. Repeat applies a previous operation again where Excel supports repeating it. This distinction matters because Ctrl+Y may be associated with redo when an undone action is waiting, while Excel can also use repeat behavior in suitable contexts. The function key F4 is commonly used to repeat the last action in Excel when that action is repeatable; it is not a way to browse old edits.
For example, if you have undone a cell edit, use Ctrl+Y to restore that edit. If you want to apply the same formatting to another selection, select the new cells and try F4, provided the formatting operation can be repeated. If F4 does not repeat the change, use the ribbon command or Format Painter instead. These tools apply an operation; they do not recover an action removed from the undo history.
Limits and safer ways to recover work
Redo is intended for recent actions in the open editing session, not long-term recovery. Closing a workbook and reopening it is not a reliable way to preserve an undo sequence. If you need to return to an earlier version, use an available saved copy or, for files stored in OneDrive or SharePoint, check whether Version History is available for that file and account.
Before carrying out a large change, consider saving a copy of the workbook, particularly before running a macro, deleting a large range, or making a bulk transformation. For smaller edits, check a selection before applying a command and use Undo promptly if the result is wrong. These habits are more reliable than expecting redo to work after many unrelated changes.
When recovering a deleted value, first try Ctrl+Z if the deletion just happened. If you have already performed another edit and the deletion is no longer in the undo history, look for the value in a saved version, backup, or another copy of the file. Redo will only reapply a deletion that was undone; it cannot retrieve a deletion that Excel no longer tracks.
Frequently Asked Questions
What is the redo shortcut in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Y to redo an action you have just undone. On a Mac, press Command+Y. The Redo button on the Quick Access Toolbar provides a mouse alternative.
Can I redo more than one action?
Usually, yes. After undoing multiple actions, press the redo shortcut repeatedly to move forward through the available sequence. Review the worksheet as you go, since Excel may group related changes into a single undoable action.
Why is Ctrl+Y not working in Excel?
There may be no undone action available, a new edit may have replaced the redo sequence, or another program may be intercepting the shortcut. Click Excel’s Redo button to check whether the command is available. If it is disabled, that action is no longer in the current redo history.
Does redo recover a file after I close Excel?
No. Redo is for actions still available in the current undo history, not for recovering a closed workbook or an older saved state. Check a backup, saved copy, or Version History where available to find an earlier file version.
Is F4 the same as Ctrl+Y?
No. Ctrl+Y redoes an undone action when one is available. F4 is commonly used to repeat the last repeatable operation on another selection. Which behavior is useful depends on whether you are restoring an undone change or applying an operation again.
Related
- Weighted Average in Excel PivotTables: How to Calculate
- Calculate Time-Weighted Average in Excel with Examples
- Calculate ROI in Excel Over Multiple Years
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Insert Row Shortcut on macOS: Keys and OptionsIn Excel for Mac, select the row where the new row should go, then press Control+Shift+= (the plus…
- Microsoft Word Styles: How to Apply and Customize ThemTo use styles in Microsoft Word, place the cursor in a paragraph and choose a style from Home…
- How to Delete a Page in the Middle of a Word DocumentTo delete a page in the middle of a Word document, place the cursor on that page, select…
- How to Generate a Timeline in PowerPointTo generate a timeline in PowerPoint, choose Insert > SmartArt > Process > Basic Timeline, then add milestone…
- Excel Conditional Formatting: Color Rows by Cell TextYes. In Excel for Microsoft 365, select the rows you want to format, create a formula-based conditional formatting…
- Outlook Export Contacts: CSV Steps and Common FixesTo export Outlook contacts, open People and choose Manage contacts > Export contacts in new Outlook or Outlook…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.