Undo, Redo, Repeat Actions in Excel: Full Guide

Excel’s Undo, Redo, and Repeat commands are the safety net for every edit you make—they let you reverse mistakes, restore accidental deletions, and instantly reapply a formatting or data-entry action. This guide covers the keyboard shortcuts, toolbar buttons, and the on-screen Quick Access Toolbar options, plus how to control how many steps Excel remembers. No setup is needed; these features work in every current version of Excel for Windows and Mac.

What You’ll Need

• A computer with Microsoft Excel (2013 or later, including Microsoft 365).
• A workbook with at least one sheet containing data or formatting you can edit.
• Optional: a mouse or trackpad if you prefer clicking buttons over keyboard shortcuts.

Step-by-Step

Undo an Action

1. Use the keyboard shortcut: Press Ctrl+Z (Windows) or Command+Z (Mac). Each press reverses one previous action, working backward from the most recent edit.
2. Use the Quick Access Toolbar: Look at the top-left corner of the Excel window, above the ribbon. Click the curved arrow pointing left (the Undo button). Each click undoes one step.
3. Undo multiple steps at once: Click the small drop-down arrow next to the Undo button. A list of your recent actions appears (e.g., “Typing ‘Sales’�, “Format Cells�, “Delete Row�). Click any item in that list to undo everything down to and including that action. Note: you cannot skip steps—undoing the third item also undoes the first two.

Redo an Action

1. Use the keyboard shortcut: Press Ctrl+Y (Windows) or Command+Y (Mac). This reapplies the last action you undid, in the same order you undid them.
2. Use the Quick Access Toolbar: Click the curved arrow pointing right (the Redo button). It only becomes active after you have undone at least one action. If it is greyed out, there is nothing to redo.
3. Redo multiple steps: Click the drop-down arrow next to the Redo button (if available) and choose a step from the list. Like Undo, this redoes everything up to that point.

Repeat the Last Action

1. Use the keyboard shortcut: Press Ctrl+Y (Windows) or Command+Y (Mac). When there is nothing to redo, the same shortcut switches to Repeat. It repeats the very last action you performed—for example, if you just applied bold to a cell, pressing Ctrl+Y applies bold to the currently selected cell.
2. Use the Repeat button: On the Quick Access Toolbar, look for the Repeat button (a circular arrow with a small dot). It appears only when the last action can be repeated. Click it to repeat that action on the current selection.
3. Repeat with F4 (Windows only): Press F4 after an action to repeat it. This works for formatting, inserting rows, deleting rows, and many other commands. On a laptop, you may need to hold the Fn key and press F4.

Adjust How Many Undo Levels Excel Remembers

1. Open Excel Options: Click File > Options (Windows) or Excel > Preferences (Mac).
2. Find the Undo setting: In Windows, go to Advanced and scroll to the Editing options section. Look for “Maximum number of undo levels� (default is 100). In Mac, go to General and look for “Undo levels�.
3. Change the number: Type a higher number (up to 100 in most versions; some newer builds allow more) and click OK. This setting applies to all workbooks in that Excel session.

Common Mistakes

• Closing the workbook without saving: Undo history is cleared when you close Excel. If you close without saving, you lose all undo steps—even if you reopen the file.
• Running a macro or VBA script: Most macros clear the undo stack. After running a macro, you cannot undo the changes it made.
• Using “Saveâ€� too early: Saving does not clear undo history, but if you save and then make a mistake, you cannot undo back past the save point if you close and reopen.
• Clicking the wrong arrow: The Redo arrow (pointing right) is easy to confuse with the Repeat button. Redo only works after an Undo; Repeat works after any action.
• Forgetting that Repeat only works for the last action: If you type text, then click a different cell, pressing Repeat will not retype the text—it will repeat the cell selection change (which does nothing). Repeat only works for actions that can be applied to a new selection.

Tips

• Memorize the three shortcuts: Ctrl+Z (undo), Ctrl+Y (redo/repeat), and F4 (repeat on Windows). These are the fastest way to work.
• Use Undo after a failed paste: If you paste data into the wrong location, press Ctrl+Z immediately—it reverses the paste cleanly.
• Repeat formatting across cells: Format one cell (e.g., yellow fill, bold). Then select other cells and press F4. This applies the same formatting to each new selection.
• Combine Repeat with Find & Replace: After replacing text in one range, select another range and press F4 to repeat the replacement there (if the same criteria apply).
• Keep undo history long: If you do complex work, set the undo levels to 100 (the maximum in most versions) so you can step back further if needed.
• Use Undo to compare versions: Make an edit, then undo and redo to see the before/after effect quickly.

Troubleshooting

• Undo button is greyed out: This means there are no actions to undo. Either you just opened the file, or you already undid everything. Check if you have made any edits since opening.
• Redo button is greyed out: You have not undone anything yet. Perform an undo first, then the Redo button becomes active.
• Ctrl+Z does nothing: Make sure the active window is Excel, not another program. Also check if a macro or add-in has cleared the undo stack.
• Undo only goes back a few steps: The undo history is limited (default 100). If you have performed more than 100 actions, the oldest ones are gone. Increase the limit in Options as described above.
• Repeat (Ctrl+Y) is redoing instead of repeating: This happens when you have undone something earlier. To repeat instead, perform a new action first, then press Ctrl+Y.
• F4 does not repeat: On some laptops, F4 is assigned to a hardware function (like brightness). Hold the Fn key while pressing F4, or change the function key behavior in your system BIOS/settings.

Frequently Asked Questions

Can I undo after saving the file?

Yes, saving does not clear the undo history. You can still undo actions performed before the save, as long as you have not closed the workbook.

Is there a limit to how many times I can undo?

Yes, the default limit is 100 actions. You can change this in Excel Options (Advanced > Editing Options > Maximum number of undo levels) up to 100 in most versions.

Why does my undo not work after running a macro?

Macros and VBA code clear the undo stack when they run. This is a built-in Excel behavior; you cannot undo changes made by a macro.

What is the difference between Redo and Repeat?

Redo reapplies an action you just undid. Repeat applies the last action you performed to a new selection. They share the same shortcut (Ctrl+Y) but behave differently depending on context.

Does Undo work on all Excel actions?

Most actions are undoable, including typing, formatting, inserting/deleting rows, and changing column widths. Some actions like saving, closing a workbook, or running a macro are not undoable.

Can I undo a closed workbook?

No. Once you close a workbook, the undo history is lost. If you did not save, you may be able to recover a previous version from the AutoRecover folder, but the undo stack itself is gone.

Related

• Stop iPhone Duplicate Notifications: 7 Fixes
• iPhone Frozen Won’t Turn Off? Force Restart Fix
• Fix Class Not Registered Error in Windows 10