How to Redo in Excel: Shortcuts, Limits, and Common Confusion

How to Redo in Excel: The Quick Answer

The fastest way to redo in Excel is the keyboard shortcut Ctrl + Y on Windows or Cmd + Y on Mac. The shortcut reverses your last undo, restoring whatever change you had just undone. The same shortcut also works as repeat action in some contexts.

The redo button on the Quick Access Toolbar (the small toolbar above the ribbon) is the visual alternative — a curved arrow pointing right that becomes active after you have used undo. The redo function is only available when there is something to redo; if you have not undone anything, the redo button greys out and Ctrl + Y has no effect.

Many users confuse undo (Ctrl + Z) and redo (Ctrl + Y). Undo reverses your last action — typing, deleting, formatting, anything that changed the workbook. Redo reverses the undo, putting back what you removed. Pressing Ctrl + Z then Ctrl + Y returns the workbook to its original state. Repeated Ctrl + Z continues stepping back through the history; repeated Ctrl + Y returns forward through the history. Both functions work as long as Excel has actions in its undo/redo history — typically up to 100 actions, after which the oldest actions drop off the history.

The third shortcut worth knowing is F4 on Windows, which repeats the last action. F4 is subtly different from Ctrl + Y. F4 takes your last action (formatting a cell yellow, for instance) and applies it to the current selection or wherever you click next. Ctrl + Y specifically reverses an undo. In Excel, F4 sometimes acts like Ctrl + Y when no actions have been undone, but its true purpose is repeating an action across new selections. Knowing the distinction prevents confusion when one shortcut behaves differently than expected.

Why does Excel even have a redo function? The most common scenario: you accidentally undid one too many times. You meant to step back two changes, but you stepped back three. Redo lets you go forward one step without retyping or re-formatting from scratch. Without redo, every accidental over-undo would require manually reconstructing the lost work. Redo is the safety net for the safety net — undo protects you from accidental changes; redo protects you from accidental undos.

Method 1: Keyboard Shortcut Ctrl + Y

Press Ctrl + Y on Windows (or Cmd + Y on Mac) to redo the most recently undone action. The shortcut works in any Excel context — cell editing, formatting, formula entry, sheet operations, file operations within session. Each press of Ctrl + Y advances forward one step through the undo history. If you undid five actions and then press Ctrl + Y five times, all five actions are restored. The order of redo restoration matches the original order of those actions — the first action you undid (most recently performed) is redone first, then earlier actions in sequence.

Mac users also have Cmd + Shift + Z as an alternative redo shortcut. Both Cmd + Y and Cmd + Shift + Z work in Excel for Mac. Older Mac applications sometimes use Cmd + Shift + Z exclusively because they do not implement Cmd + Y; Excel for Mac supports both because Excel originated on Windows where Ctrl + Y is standard. The shortcut consistency between Windows and Mac is helpful for users who switch between platforms — Ctrl + Y / Cmd + Y always means redo.

The shortcut order matters. Pressing Ctrl + Z six times then Ctrl + Y three times leaves you three steps back from the original state, not at the original state. Each Ctrl + Y reverses one Ctrl + Z. Counting your undos and redos as you press the shortcuts helps maintain awareness of where you are in the history. Excel does not display a step counter for the undo state, so users have to track this mentally during heavy undo/redo sessions.

Method 2: The Quick Access Toolbar Redo Button

The Quick Access Toolbar appears at the very top of the Excel window above the ribbon (or below if you have moved it). The default Quick Access Toolbar includes Save, Undo, and Redo buttons. The Redo button is a curved arrow pointing right (the Undo button points left). Click the Redo button to redo the most recently undone action. The button greys out when there is nothing to redo. The dropdown arrow next to the Redo button shows the recent redo history — click on any entry to redo multiple actions at once back to that point.

Customising the Quick Access Toolbar is useful for adding shortcuts to functions you use frequently. Right-click the toolbar and select Customize Quick Access Toolbar to add commands like Print, Save As, or AutoFilter. Some users add a Repeat command (different from Redo) for the F4 functionality. The toolbar becomes a personal Excel shortcut bar for high-frequency commands. Like understanding Absolute Reference Excel behaviour, customising the QAT is a small investment that pays back across many sessions.

The Quick Access Toolbar position can be changed. Right-click the toolbar and choose Show Quick Access Toolbar Below the Ribbon (or Above) to position it where it suits your workflow. Below the ribbon places it closer to your editing area; above keeps it in the title bar. Both work; preference varies by user. The toolbar is also customisable through the right-click menu — adding commonly used commands like Print, Save As, Format Painter, or Repeat speeds frequent operations beyond just undo and redo.

Undo vs Redo: The Critical Distinction

Undo and redo are two halves of the same mechanism but they do different things. Undo (Ctrl + Z) reverses your most recent action. If you typed "hello" in a cell and press Ctrl + Z, the cell reverts to its prior value. If you formatted a range yellow and press Ctrl + Z, the formatting reverts. Each press of Ctrl + Z steps backward through your action history. The undo button on the Quick Access Toolbar is the visual equivalent — curved arrow pointing left.

Redo (Ctrl + Y) reverses the undo. After you have undone an action, redo puts it back. The redo button is the curved arrow pointing right. Each press steps forward through the history. Redo only works after undo — there is no concept of redoing an action that was never undone.

The redo button stays greyed out until you have used undo at least once. This is the source of most confusion: users press Ctrl + Y expecting it to do something useful, but with no undo history, it does nothing. The fix is realising that redo is paired with undo and only meaningful in that context.

Mental models matter for fluent shortcut use. One useful framing: Ctrl + Z (undo) is like backspace for actions; Ctrl + Y (redo) is like the right arrow that moves forward through what you backspaced over. The undo history is a path of changes; you can walk backward (undo) or forward (redo) along the path. New actions create a new branch that wipes whatever was forward of the current position. Visualising the history as a linear path makes the behaviour predictable.

Excel Undo/Redo History Limits

Excel maintains 100 undo/redo actions by default. After 100 actions, the oldest action drops off the history when each new action is added. The 100-action limit is generous for most workflows but can be reached during heavy editing sessions involving many small actions. Once an action drops off the history, it cannot be undone; once an undone action drops off, it cannot be redone. Saving frequently and limiting unnecessary actions helps preserve undo history for important changes.

The undo limit can be increased on Windows up to 200 actions through registry editing. The path is HKEY_CURRENT_USER\Software\Microsoft\Office\xx.0\Excel\Options where xx.0 is your Excel version. Add a DWORD value named UndoHistory with decimal value up to 200. Restart Excel for the change to take effect. Macs do not have an equivalent setting through standard interfaces. Increasing the limit beyond 200 is not supported and may cause performance issues. Most users do not need to modify the default limit.

The 100-action limit refers to user-visible actions, not low-level operations. Excel groups related operations into single user-visible actions for undo purposes. Pasting 1,000 cells counts as one undo action even though it affected 1,000 cells. Filling 50 cells with a formula counts as one action. Format painter applied to a range counts as one action. The grouping means typical workflows reach the 100 action limit slowly even during heavy editing sessions.

Some operations cannot be undone regardless of history limit. Saving the file is not undoable (the prior file version is overwritten). Closing the file is not undoable. Sheet deletion is undoable in modern Excel but was not in older versions. Operations that involve the file system or external systems are typically outside undo scope. The undo function covers content changes within the workbook; file-level operations have separate considerations.

Persistence Across Save and File Operations

Excel 365 maintains undo/redo history across save operations within the same session. You can save the file mid-task, continue working, undo and redo as needed, and the history remains intact. Closing the file and reopening it does clear the history — Excel does not persist undo state to disk. The first action after reopening is always the start of a fresh undo history. AutoSave (in Excel 365 with files saved to OneDrive or SharePoint) operates similarly — it saves changes but does not affect the in-memory undo history.

Multi-user co-authored workbooks have additional considerations. When multiple users edit the same workbook simultaneously through OneDrive or SharePoint, undo/redo affects only your own changes — not other users' changes. Pressing Ctrl + Z in a co-authored workbook reverts your last change, not the most recent change in the workbook overall. This prevents users from accidentally undoing each others' work. Workbooks like Budget Template Excel shared across teams use this pattern when collaborative editing happens.

The session boundary that clears undo/redo history is when the file closes — not when it saves. Auto-recovery files generated by Excel preserve content but not undo history. If Excel crashes and recovers a file, the recovered file starts with empty undo history regardless of how many actions had accumulated in the original session. Saving frequently is the practical safeguard against losing work; relying on undo history to reverse changes after a crash does not work.

Troubleshooting When Redo Doesn't Work

Redo button greyed out is the most common issue. The cause is usually simple: nothing has been undone, so there is nothing to redo. Pressing Ctrl + Z first creates the undo state that Ctrl + Y can then reverse. Other causes: the file was just opened (no actions in current session yet), the undo history limit was reached and oldest actions including the desired redo dropped off, or a new action wiped the redo branch. Each cause requires different remedy — the new-action wipe is irreversible because Excel does not maintain branching history.

Ctrl + Y not working when redo button is active suggests a keyboard or shortcut conflict. Some keyboard utilities or third-party software remap Ctrl + Y to other functions. Test by clicking the Redo button directly — if the button works but Ctrl + Y does not, a shortcut conflict exists. Checking Excel Options → Customize Ribbon → Keyboard Shortcuts confirms whether the shortcut is properly mapped. Some non-US keyboard layouts have different shortcut conventions; Mac and Windows differences also produce occasional confusion when users switch between platforms.

Some keyboard layouts or input methods can interfere with shortcuts. Users with non-US keyboard layouts sometimes find that Ctrl + Y produces a different action because the Y key is in a different position or mapped differently. Switching to US-international layout or remapping the shortcut through Excel Options resolves the conflict. Voice input software, screen readers, and accessibility tools also occasionally intercept shortcut combinations. Disabling these temporarily helps diagnose whether they are the source of the issue.

VBA and Macro Considerations

Running a VBA macro typically clears the undo history because Excel cannot generally reverse macro actions. After macro execution, the undo button greys out and Ctrl + Z does not work for actions before the macro. This is a frequent source of confusion — users perform a macro then realise they want to undo something earlier and find they cannot. Strategies to mitigate: save before running macros so File → Open recovers prior state; build undo support into custom macros for important operations; or use Application.Undo within macros to capture undo points where appropriate.

Sophisticated VBA developers can implement undo support within their macros for important operations. Application.OnUndo "Macro Action", "UndoMacroAction" registers a custom undo entry. The user pressing Ctrl + Z after the macro then runs UndoMacroAction which reverses what the original macro did. Implementing this for production macros adds substantial code complexity but produces user-friendly undo behaviour. Most quick-and-dirty personal macros do not bother with custom undo support; production macros distributed to other users benefit from it.

Some Excel power users keep a small log of major actions during heavy editing sessions to track which states they have visited. The log helps when undo and redo become confusing during complex work. Even a brief mental note of major checkpoint states reduces the cognitive load of tracking many actions in sequence.