Undo vs Redo Excel: What Each Command Does

How-to basics · Updated November 20, 2026

In Excel, Undo reverses your most recent change, while Redo restores a change you just undid. On Windows, press Ctrl+Z to undo and Ctrl+Y to redo; on Mac, use Command+Z and Command+Y.

Undo and redo: the basic difference

Think of Undo as stepping backward through recent edits and Redo as stepping forward again. If you enter a value in a cell and then undo, Excel removes that entry. If you immediately redo, Excel puts the value back. Redo does not normally repeat an action that you never undid; its main purpose is to restore an item from the undo history.

These commands are useful for correcting mistakes without manually recreating a previous state. For example, if you accidentally apply a fill color to a range, Undo can remove the formatting. If you then decide that the color was appropriate after all, Redo restores it. The commands apply to workbook actions that Excel has recorded, not to every event that happens on your computer.

Undo and Redo are not the same as clearing a cell or editing a value again. Clearing a cell is a new action; Undo reverses the latest recorded action. That distinction matters when several changes have happened in a row, because one press of Ctrl+Z reverses one step, not necessarily the entire task.

How Excel’s undo and redo history works

Excel keeps a sequence of recent actions so you can move backward through them. After you undo an action, Excel makes that action available to redo. You can undo several steps in succession, and, while no new action interrupts the sequence, redo those steps in the opposite order. The sequence follows the order in which Excel recorded the actions.

For example, suppose you type a number in B2, make it bold, and change its font color. If you undo once, Excel reverses the font-color change. Undo again to remove bold, and a third time to undo the entry. Redo restores those changes in reverse order: the entry first, then bold, then the font color.

The Undo and Redo controls on Excel’s Quick Access Toolbar can show a dropdown list of recent actions. Choosing an earlier point in the list undoes that action and the later actions above it as a group. The Redo list works similarly for actions that have been undone. This can be more convenient than pressing a shortcut repeatedly, especially when you need to back out several edits.

Redo history is fragile: if you undo something and then make a new workbook change, Excel discards the redo path that was available. For instance, undo a formatting change, then type a new value in another cell, and the earlier formatting change may no longer be available through Redo. If you are unsure whether you want to keep an undone action, redo it before making another edit.

Keyboard shortcuts and toolbar controls

For Excel for Microsoft 365 on Windows, the standard shortcuts are Ctrl+Z for Undo and Ctrl+Y for Redo. On Excel for Mac, use Command+Z and Command+Y. The Quick Access Toolbar also provides Undo and Redo buttons; their location can vary depending on how the toolbar is configured, but they are usually near the top of the Excel window.

  • Undo one action: Press Ctrl+Z on Windows or Command+Z on Mac, or select the Undo button.
  • Undo several actions: Press the shortcut repeatedly, or use the Undo dropdown to choose a point in the recent action list.
  • Redo an undone action: Press Ctrl+Y on Windows or Command+Y on Mac, or select the Redo button.
  • Redo several actions: Repeat the shortcut or use the Redo dropdown, if it is available.

In Excel for the web, Undo and Redo are available from the toolbar, and keyboard shortcuts generally follow the same platform conventions: Ctrl+Z and Ctrl+Y on Windows, or Command+Z and Command+Y on Mac. If a shortcut does not appear to work, use the on-screen controls; the browser, keyboard layout, or focus in a text-entry field can affect which command receives a keystroke.

Excel also uses F4 in some Windows contexts to repeat the last action, but F4 has other jobs, including changing cell-reference types while editing a formula. Do not treat F4 as a universal substitute for Redo. Use Ctrl+Y when your goal is specifically to restore an action you just undid.

Examples: what happens to common edits

Undo is useful for many ordinary spreadsheet edits, including entering or deleting cell contents, applying formatting, inserting or removing rows and columns, and changing some worksheet settings. The exact action history depends on what you did and how Excel handled it. Here are a few practical examples:

  • Wrong value: If you type 250 in C5 instead of 25 and commit the entry, Undo reverses the entry. Redo puts 250 back if you have not made another change.
  • Accidental formatting: If you apply a number format to a range by mistake, Undo can reverse that formatting step without requiring you to identify and reapply each cell’s previous format manually.
  • Deleted contents: If you clear a cell or range, Undo may restore the contents and formatting affected by that operation. Check the result carefully, particularly if you had selected a large range.
  • Several steps to reverse: If you enter a value, bold the cell, and then add a border, three Undo steps can take you back through those recorded changes one by one.

Undo reverses actions, not intentions. If you selected the wrong range before applying a format, Excel will generally undo the format operation; it does not know that you meant to format a different range. Likewise, undoing a formula entry removes that entry, but it does not diagnose why the formula was incorrect or automatically write a corrected formula for you.

Redo versus repeating an action

People sometimes use “redo” to mean “do that operation again,” but Excel distinguishes restoring an undone action from repeating an action where possible. Redo is tied to the undo history: it brings back an action that was reversed. Repeating means applying a previous operation again, such as applying the same formatting to another selection, when Excel supports repeating that operation.

This difference explains why Redo may be unavailable even though you recently performed an action. If you have not undone anything, there may be no action waiting to be redone. Some Excel commands can instead be repeated with a shortcut or command, but not every action can be repeated, and the available behavior depends on the command and the current selection. When a shortcut seems to do something unexpected, check whether Excel is in formula-editing mode or whether the command is repeating an action rather than restoring an undone one.

A useful rule is: use Undo to take back a recent change, then use Redo to restore that same change if you change your mind. If your goal is to apply the same operation to a different cell or range, use the relevant formatting or editing command again rather than relying on Redo.

Limits and actions Excel may not undo

The undo history is not a permanent audit log or a complete backup. Some operations cannot be undone, and some actions performed outside Excel do not belong to the workbook’s undo sequence. Running a VBA macro is a particularly important example: macros generally clear Excel’s undo history, and the changes made by a macro cannot be reversed with Ctrl+Z. Save a separate copy of the workbook before running a macro if you may need to return to the previous state.

Other actions can have special limits. Operations involving external data, connections, add-ins, or other programs may not behave like ordinary cell edits, and the undo options available can vary. If an action affects data outside the workbook, do not assume that Excel’s Undo command will reverse the external effect. Check the relevant program or service and preserve a backup before carrying out a high-impact operation.

Undo also cannot recover a change after its history is gone. Making a new edit after undoing can remove the redo path; closing a workbook or encountering an operation that clears the history can also leave you without the expected steps. Excel’s undo stack is intended for recent editing, not long-term recovery. For an important workbook, use saved copies or cloud version history as an additional safeguard.

When undo is not enough: recovery options

If the change is no longer available through Undo, first avoid making more edits. Then consider whether the workbook has a saved earlier version. For files stored in OneDrive or SharePoint, Excel can provide Version History; in Microsoft 365 for Windows, you can usually open it from the workbook’s title bar or through File > Info > Version History. The exact interface can vary with the account and storage location.

Version History is different from Undo. Undo reverses recent actions in the current editing session, while Version History lets you inspect or restore an earlier saved version of a cloud-stored file. Before restoring an older version, check its date and contents. If the current workbook contains useful later work, save a copy or compare the versions first so that restoring an earlier state does not discard changes you want to keep.

For files on a local drive, look for a separate copy, a backup, or an available recovery version. Excel’s recovery options depend on settings and whether a recoverable copy was created. Autosave or AutoRecover can help in some situations, but neither is a reason to treat the undo list as permanent storage. Saving a clearly named copy before a risky change is often the simplest fallback.

Practical habits for safer editing

A few habits make Undo and Redo more predictable and reduce the chance that an accidental edit turns into lost work:

  • After an unexpected result, pause and use Undo before making additional edits that might replace the redo history.
  • Use the Undo dropdown to review the sequence when you are not sure how many steps need reversing.
  • Check the selected cells before applying a format, deleting contents, or changing a large range.
  • Save a separate workbook copy before running a macro or performing a high-impact operation.
  • Use cloud Version History or independent backups for work that needs recovery beyond the current editing session.

These precautions are especially helpful in large workbooks, where a selection can include more cells than expected or where a later edit makes the original redo path unavailable. Undo is a fast correction tool; a saved copy is a more reliable recovery plan.

Frequently Asked Questions

What is the shortcut for Undo and Redo in Excel?
On Windows, Ctrl+Z undoes and Ctrl+Y redoes. On Mac, Command+Z undoes and Command+Y redoes. You can also use the Undo and Redo buttons on the Quick Access Toolbar.

Why is Redo greyed out in Excel?
Redo is unavailable when there is no recent undone action to restore. It may also disappear after you make a new change following an undo, because that new action replaces the previous redo path.

Can I undo several actions at once?
Yes. Press the Undo shortcut multiple times, or use the dropdown beside the Undo button to choose an earlier point in the action list. Excel reverses the selected action and the later recorded actions along with it.

Can I undo a macro in Excel?
Usually not with Ctrl+Z. Running a VBA macro generally clears the regular undo history, and Excel cannot automatically reverse the macro’s changes. Save a separate copy before running a macro you may need to roll back.

Does saving the workbook remove Undo history?
Saving is not the same as undoing or redoing, and the availability of recent actions depends on the operation and session. Do not rely on Undo as a durable backup; use a separate copy or Version History for recovery over time.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.