To redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y after you have undone something. You can also select Redo on the Quick Access Toolbar. Redo reapplies an action that you just reversed; it does not recover every change in every situation, so check the workbook and the command’s availability if the shortcut does not work.
This guide covers the desktop app first, with notes for Excel for Mac and Excel for the web. Redo is useful when you undo a change by mistake, such as deleting a value or applying formatting, and then want to put that change back without repeating it manually.
What You’ll Need
- A workbook open in Microsoft Excel. If the change matters, save a separate copy before trying a complex recovery.
- A keyboard or access to Excel’s Quick Access Toolbar. The shortcut is usually the fastest method, but the toolbar provides a visible alternative.
- A recent action that Excel can redo. Redo is available only while Excel retains that action in its undo history.
Step-by-Step
- Check that you are in the right workbook. If several workbooks are open, click the window containing the cells or formatting you want to restore. Excel keeps undo and redo history for the current editing session, and switching workbooks can change which history is active.
- Undo the action if you have not already. Press
Ctrl+Zon Windows, or click the left-curving Undo arrow on the Quick Access Toolbar. For example, if you typed 250 into B4 and then pressed Undo, Excel should restore the previous contents of B4. Redo becomes relevant after this reversal. - Confirm that Redo is available. Look at the Quick Access Toolbar, normally near the top of the Excel window. The right-curving arrow is the Redo control. If it appears disabled or unavailable, Excel may have no undo action to restore, or a later action may have replaced the redo history. Do not keep pressing keys without checking what is selected.
- Use the Windows shortcut. Press
Ctrl+Yonce. Excel should reapply the most recently undone action. If you just undid typing in B4, the value 250 should return. If you undid a formatting change, that formatting should be restored instead. Check the affected cells before continuing. - Redo more than one undone action, if needed. Press
Ctrl+Yagain for each additional action you want to reapply. Excel restores actions in the reverse order from which you undid them: the latest undone action comes back first. Pause after each press, especially if the earlier actions affected many cells or worksheets. - Use the toolbar instead of the keyboard when preferred. Click the Redo arrow on the Quick Access Toolbar. If the arrow has a small dropdown, open it to inspect the available redo actions, then select the relevant entry if Excel displays a list. The toolbar is useful when you are unsure whether the shortcut is being intercepted by another control.
- Check the result and save when it is right. Review the changed cell, range, or worksheet, and confirm that the restored content or formatting is what you intended. If the workbook is in a shared or important workflow, save after verifying the result. Saving preserves the current workbook state, but it does not make Redo available for actions Excel no longer has in its history.
In Excel for Mac, the usual redo shortcut is Command+Y. The Undo shortcut is Command+Z. If you use a different keyboard layout or the shortcut is captured by another feature, click the Redo control on the Quick Access Toolbar instead. In Excel for the web, use Ctrl+Y on Windows or Command+Y on Mac when supported by your browser and keyboard setup; the toolbar’s Redo arrow is another option.
Common Mistakes
- Pressing Redo before undoing anything. Redo is not a general repeat button for every command. Its usual job is to restore an action that was just undone. If you have not undone an action, the Redo arrow may be inactive or the shortcut may behave differently depending on the context.
- Confusing Redo with Repeat. Excel can repeat certain previous actions, and
F4is commonly used to repeat the last action in Windows desktop Excel when that action is repeatable. Redo, by contrast, re-applies an item from the undo history. Some commands and contexts treat shortcuts differently, so use the toolbar tooltip or menu label to confirm which command is available. - Pressing the shortcut too many times. Each press can restore another action. If you only meant to reverse one Undo, repeated presses might also restore older changes you had intentionally undone. Use one press at a time and inspect the sheet.
- Assuming every action can be restored. Some operations, external data changes, macros, or actions performed by add-ins may not be included in Excel’s ordinary undo history. If Redo is disabled, pressing the shortcut repeatedly will not recreate an action that Excel no longer tracks.
- Using the wrong key combination for the device. Windows uses
Ctrl+Y; Mac usesCommand+Yin the usual setup. Pressing Ctrl on a Mac, or Command on a Windows PC, will not normally invoke the expected redo command.
Tips
- Use the toolbar as a visual check. Hover over the curved-arrow icon to see its tooltip. Depending on the current state, Excel labels the command Redo or may show the action that will be restored. This helps distinguish the control from Undo.
- Make a small test before a large recovery. If you are uncertain which operation is next in the history, press Redo once and inspect the result. You can then decide whether another press is appropriate.
- Keep a separate copy before risky work. Redo and Undo are convenient for ordinary edits, but they are not a substitute for a backup. Use File > Save As to create a copy before running unfamiliar procedures or making extensive changes.
- Remember that Redo follows the undo sequence. If you undo several actions, Excel restores them in sequence, starting with the one you undid most recently. This makes it possible to recover a short chain of edits, but it is not a way to choose any historical version of the workbook.
- Check whether the cell is being edited. If the cursor is inside a cell or the formula bar, a keystroke may edit text rather than trigger a workbook command. Press
Escto cancel the current cell edit, orEnterto commit it, then try the Redo command.
Troubleshooting
Ctrl+Y does nothing. First check the Quick Access Toolbar. If Redo is greyed out, there is no available action for Excel to restore. If it is active, click the arrow directly; this helps determine whether the keyboard shortcut is being intercepted by another application, browser, keyboard utility, or active control. On Mac, try Command+Y rather than Ctrl+Y.
The wrong change comes back. Stop pressing Redo and inspect the affected cells. Excel processes the redo history in order; it does not offer a search across every prior version. If the result is not wanted, press Undo once, then consider whether the action can be recreated manually or recovered from a saved copy. Avoid making unrelated edits until you understand the current history.
The Redo arrow disappeared or is hard to find. In Windows desktop Excel, the Quick Access Toolbar can be above or below the ribbon and can be customized. Open its customization menu and choose Show Quick Access Toolbar if it is hidden. You can also use File > Options > Quick Access Toolbar to add the Redo command, if it is not already shown. On Mac, use the Quick Access Toolbar customization options available in Excel’s interface.
Redo is unavailable after using a macro or another operation. Some actions clear or bypass Excel’s normal undo history. If a macro changed the workbook, Excel’s standard Undo and Redo controls may no longer be able to reverse or repeat those changes. Do not rerun a macro just to test it. If the change is important, close without saving only if you are certain that doing so will not discard other needed work; otherwise, recover from a backup or an available version history.
The workbook looks different after restoring an action. Redo may restore more than one visible detail if the original action affected a selected range, an entire row or column, or multiple cells. Check the range and the formula bar, and inspect neighboring cells before assuming Excel has changed the wrong value. If working in a shared workbook, allow edits to finish syncing before judging the final result.
Frequently Asked Questions
What is the redo shortcut in Excel for Windows?
In Excel for Microsoft 365 on Windows, press Ctrl+Y to redo the most recently undone action. You can also click the Redo arrow on the Quick Access Toolbar. Press once, check the result, and repeat only if you want to restore another undone action.
What is the redo shortcut in Excel for Mac?
The usual shortcut in Excel for Mac is Command+Y. The Mac Undo shortcut is Command+Z. Keyboard layouts and app contexts can affect shortcuts, so use the Redo arrow in the toolbar if the keyboard command does not work.
Can I redo an action after closing the workbook?
Usually, no. Excel’s undo and redo history is for the current editing session and is not a permanent list of workbook versions. After closing and reopening a file, use a saved copy or an available version-history feature if you need an earlier state.
Why is Redo greyed out in Excel?
Redo is greyed out when Excel has no eligible undone action to restore. You may not have undone anything, or a later operation may have cleared the redo history. Some macros and other operations do not work with the standard undo stack, so Redo cannot restore them.
Can I redo several actions at once?
You can press the redo shortcut repeatedly, but each press restores the next action in the sequence. Some Excel toolbar versions may show a dropdown of available actions. Restore one at a time and inspect the worksheet so you do not reapply changes you meant to leave undone.
Is Ctrl+Y the same as F4 in Excel?
Not exactly. Ctrl+Y is the Windows redo shortcut when Excel has an undone action to restore. F4 can repeat a previous action in certain desktop contexts, but it does not provide the same history-based recovery. What F4 repeats depends on the operation and the current editing context.
Related
- Open Excel for the Web in the Desktop App
- Open Power Query in Excel for the Web: Step-by-Step
- How to Open a SharePoint Excel File in the Desktop App
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Copy Horizontal to Vertical in Excel: Transpose DataTo copy a horizontal row into a vertical column in Excel, select and copy the row, choose the…
- How to Copy Down in Excel with the Fill Handle or ShortcutTo copy down in Excel, enter or select the content in the top cell, select the cells below…
- Auto Filter in Google Sheets: Setup and TipsTo use an auto filter in Google Sheets, select your table, then choose Data > Create a filter.…
- Excel Power Query Tutorial for BeginnersTo use Power Query in Excel for Microsoft 365 on Windows, select your data source from the Data…
- Can You Automate Goal Seek in Excel? Methods That WorkYes. In Excel for Microsoft 365 on Windows, you can automate Goal Seek with a VBA macro; in…
- Workout Log Google Sheets: Build a Useful TrackerYes—you can make a workout log in Google Sheets by creating a table for dates, exercises, sets, reps,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.