Excel Undo Shortcut: Keys, Limits, and How It Works

In Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action. On a Mac, press Command+Z. Press the shortcut again to undo earlier actions, or select the Undo button on the Quick Access Toolbar.

The Excel undo shortcut on Windows and Mac

Ctrl+Z is the standard undo shortcut in Excel for Windows. It works for common changes such as typing or deleting cell contents, applying formatting, and inserting or deleting rows. The command reverses the most recent action that Excel has recorded, not necessarily just the change to the currently selected cell.

On a Mac, use Command+Z rather than Ctrl+Z. Excel for the web also supports Ctrl+Z on Windows and Command+Z on Mac. If you prefer not to use a keyboard, look for the curved left-arrow Undo button on the Quick Access Toolbar. Its position can vary depending on how the toolbar is configured.

If the Undo button is dimmed, Excel has no available action to reverse in the current undo history. Check that the workbook window is active and that Excel has finished any operation in progress. The button and shortcut perform the same basic undo command.

What Undo changes—and what it leaves alone

Undo reverses recorded editing actions. For example, if you type a value into a cell and press Enter, Ctrl+Z removes that entry. If you then change a cell’s fill color, pressing Ctrl+Z once reverses the color change; pressing it again reverses the earlier entry, assuming no other action intervened.

The selection itself is generally not an edit. Moving from A1 to B1, scrolling, or clicking a different worksheet does not ordinarily create a change for Undo to reverse. This is why Ctrl+Z does not work like a way to travel backward through every click or selection you made.

Excel can record many kinds of actions, including edits, formatting changes, and certain structural changes to a sheet. The exact actions available to undo depend on what you did and whether Excel retained them in its undo history. Treat Undo as a way to reverse recent work, not as a complete record of every workbook state.

Undo several actions or choose from the history

To undo a sequence of recent changes, press Ctrl+Z repeatedly on Windows or Command+Z repeatedly on Mac. Each press steps back one recorded action. For instance, after entering a heading, bolding it, and changing its font size, three undo commands can reverse those actions in reverse order—provided no other undoable action has been added since.

You can also use the small dropdown arrow beside the Undo button on the Quick Access Toolbar to view recent actions. Selecting an earlier point in the list reverses that action and the later actions above it in the sequence. It is not a way to undo only one older action while keeping newer changes that depend on it.

Use one undo when you want to reverse only the latest recorded change.
Use repeated shortcuts when you know how many recent actions you want to step back.
Use the toolbar’s Undo list when you need to identify a particular point in the recent sequence.

If the result is not what you expected, stop before making more edits. Review the affected cells and use Redo if you reversed too far.

Undo, Redo, and Repeat are different commands

Undo reverses an action; Redo reapplies an action that you just undid. In Excel for Windows, Ctrl+Y is the usual Redo shortcut. You can also use the Redo button on the Quick Access Toolbar when it is available. On a Mac, use the Redo command or button shown by your version of Excel rather than assuming every Windows key combination is identical.

Redo is useful when you press Undo one time too many. For example, if you undo a cell’s formatting and then realize that formatting was correct, Redo can restore it. But if you make a new edit after undoing, Excel generally discards the redo path for the earlier action. The new edit starts a different sequence, so Redo may no longer bring back the change you had undone.

Repeat is another concept and should not be confused with either command. Some Excel actions can be repeated, but Ctrl+Y is commonly used as Redo in Windows and its behavior can depend on the context. In particular, while editing a formula, F4 has a separate role: it can cycle through relative and absolute cell references, such as A1 and $A$1. It is not a universal undo key.

Why some actions cannot be undone

Not every operation leaves a usable undo step. Running a VBA macro is an important example: a macro can clear Excel’s undo history, and changes made by the macro cannot generally be reversed with Ctrl+Z. Some other specialized operations may also limit or clear the history. If Undo becomes unavailable after an operation, Excel may not have a recorded step it can restore.

Undo history is also temporary rather than a permanent version log. Closing a workbook and opening it again does not restore its previous undo sequence. Saving is not a substitute for Undo, and Undo is not a substitute for a backup. For important workbooks, keep an appropriate saved copy or use the version-history features available through your storage setup.

When a change is important or difficult to recreate, save a copy before taking a risky action. This is especially sensible before running code, making a large bulk edit, or changing a workbook structure that affects many sheets. A backup gives you another recovery option if Excel has no undo step available.

When Ctrl+Z does not seem to work

If the shortcut appears to do nothing, first check whether Undo is enabled. A dimmed Undo button usually means there is no recorded action available. If the button is active but the wrong thing changes, remember that Excel reverses the latest recorded action in the workbook’s history, which may be a formatting or sheet operation rather than the value you were thinking about.

Confirm the active app: Click inside the workbook so Excel, rather than another window, receives the shortcut.
Check the key for your platform: Use Ctrl+Z on Windows and Command+Z on Mac.
Look at the Undo list: The toolbar dropdown can help identify which actions Excel is prepared to reverse.
Consider what happened immediately before: A macro or certain operations may have cleared the available history.
Avoid extra edits while troubleshooting: A new action can change the undo and redo sequence.

If the action cannot be undone, use another recovery route: restore a saved copy, check available cloud version history, or re-enter the lost information from a reliable source. Do not assume that closing Excel will recover an earlier state; it can remove the remaining undo history.

Using Undo in Excel for the web and on touch devices

Excel for the web uses the same familiar undo idea: Ctrl+Z on Windows and Command+Z on Mac. You can also use its Undo control in the toolbar. Because Excel for the web runs in a browser, keyboard focus matters. If the shortcut is handled by another part of the page or browser, click into the worksheet and try again.

On a tablet or other touch device, there may be no physical Ctrl or Command key. Use the Undo icon in the Excel interface instead. The exact placement can differ between the web app, desktop app, and mobile layout, but the curved arrow is the usual visual cue. Touch versions may also offer an on-screen keyboard, depending on the device.

Features and interface details can vary by platform and update. The reliable starting point is to use the platform’s standard undo key combination or the Undo button visible in Excel. If a toolbar control is hidden, look for the Quick Access Toolbar or the app’s editing controls rather than relying on a shortcut from another program.

A careful workflow for important edits

For ordinary cell edits, Undo is quick and convenient. For larger changes, it helps to plan a little before acting. If you are about to replace a large range, delete several rows, or apply a transformation across a sheet, make sure the intended range is selected and consider saving a copy first. This is particularly useful when the result would take time to reconstruct.

After a bulk action, check a few representative cells before continuing. If the result is wrong, use Undo immediately rather than trying to manually repair it while the original action is still in the history. If you have already continued editing, inspect the undo list carefully: reversing several steps may also remove correct work done after the mistake.

For collaborative or cloud-stored workbooks, coordinate before restoring an older version because a version restore can affect changes made after that snapshot. Undo is best for recent, clearly identified actions; backups and version history are better suited to recovering from larger or older mistakes.

Frequently Asked Questions

What is the shortcut to undo in Excel?
Press Ctrl+Z in Excel for Windows. On a Mac, press Command+Z. You can also choose the Undo button on the toolbar.

How do I undo multiple actions in Excel?
Press Ctrl+Z repeatedly on Windows or Command+Z repeatedly on Mac. Each press reverses another available action. The Undo dropdown can show recent actions and let you select an earlier point.

What is the redo shortcut in Excel?
In Excel for Windows, press Ctrl+Y to redo an action you just undid. You can also select the Redo button when it is available. On Mac, use the Redo command or toolbar control in your version of Excel.

Can I undo after closing and reopening a workbook?
Excel does not preserve the ordinary undo sequence as a permanent history after you close a workbook. To recover an older state, look for a saved copy or version history if your file’s storage location provides it.

Why is Undo greyed out in Excel?
Undo is greyed out when Excel has no available action in its current undo history. The action may not have been recorded, or an operation such as running a macro may have cleared the history.

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.