Where Did Undo and Redo Go in Excel?

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, Undo and Redo are usually in the Quick Access Toolbar at the upper left of the Excel window, above or below the ribbon. If the buttons are hidden, use Ctrl+Z to undo and Ctrl+Y to redo; you can also add the buttons back through Excel’s options.

Where to find the buttons

Look in the Quick Access Toolbar, often abbreviated QAT, near the Save icon and the workbook’s upper-left corner. Undo is shown as a curved arrow pointing back; Redo is a curved arrow pointing forward. Depending on your toolbar setup and recent actions, one or both may not be visible, and Redo may appear disabled until you undo something.

The QAT is separate from the ribbon tabs such as Home, Insert, and Data. That is why looking through the Home ribbon may not help: Undo and Redo are commonly placed in the QAT rather than presented as ordinary Home-tab commands. The toolbar can also be positioned below the ribbon, so check both areas.

If you use Excel for the web, look near the upper-left area of the workbook window for its Undo and Redo controls. The exact arrangement can vary with the web interface and window size. The keyboard shortcuts are a useful fallback in either desktop Excel or the web app.

Restore Undo and Redo on Windows

If the buttons have disappeared from the desktop QAT, add them back in Excel’s settings. In Excel for Microsoft 365 on Windows:

  1. Select File > Options.
  2. Choose Quick Access Toolbar in the Excel Options window.
  3. In the command list, find Undo, select Add, and then repeat for Redo.
  4. Use the ordering controls if you want to change their positions, then select OK.

If you do not see either command in the current list, use the list labeled Choose commands from to display a broader set of commands, such as All Commands, and look again. The customization window may show more commands than the toolbar currently contains; adding them here changes the toolbar, not the workbook’s data.

You can also check whether the QAT is merely positioned somewhere unexpected. Right-click the ribbon or toolbar area and look for the option to show the Quick Access Toolbar, or use the Quick Access Toolbar settings in Excel Options. If your organization manages Office settings, some customization choices may be restricted.

Keyboard shortcuts for undo and redo

On Windows, press Ctrl+Z to undo the most recent supported action. Press it again to step farther back through the available actions. To redo an action you just undid, press Ctrl+Y. In Excel, Ctrl+Y can also repeat the last action when there is no undone action to redo, if that action can be repeated.

On a Mac, the usual shortcuts are Command+Z for Undo and Command+Y for Redo. Excel for the web generally uses the same platform-specific keyboard conventions, though browser or operating-system shortcuts can sometimes affect what happens. If a shortcut is intercepted or does not work, use the visible Excel button instead.

Keyboard shortcuts can be quicker than reaching for the toolbar, especially when correcting a sequence of edits. For example, if you enter a value in a cell, apply bold formatting, and then change the cell’s fill color, pressing Ctrl+Z repeatedly can step backward through those recent actions. The order and availability depend on what Excel has recorded as undoable actions.

How Excel’s undo and redo sequence works

Undo moves backward through Excel’s available action history; Redo moves forward again after an undo. A Redo button is therefore not a second way to undo. If you undo an edit and then make a different new edit, the earlier redo path is generally replaced by the new sequence. In practical terms, redo is for reversing an undo, not for retrieving an edit after you have moved on and changed the workbook in another way.

When the QAT shows a small menu arrow beside Undo, opening it can display a list of recent actions. You can select a point in that list to undo that action and the later actions in the sequence. This is helpful when several operations need to be rolled back together, but read the list before choosing: selecting an earlier operation also removes the intervening changes from the current workbook state.

The controls apply to the active workbook’s available undo history, not to a permanent log of every change ever made. They are designed for correcting recent work during an editing session. They do not replace saving, version history, or a backup, and they cannot guarantee recovery of an edit that Excel no longer has available to undo.

Why a button may be missing or unavailable

A missing button and a disabled button mean different things. If Undo is not visible, the QAT may have been customized, hidden, or moved. If it is visible but greyed out, Excel may have no supported recent action to undo in the current context. Redo is normally unavailable until there is something to redo, such as an action you have just undone.

Some operations do not behave like ordinary cell edits in the undo sequence. In particular, running a VBA macro clears Excel’s normal undo history, and macro actions cannot be reversed with Ctrl+Z. Some other commands or operations involving add-ins or external processes may also not provide the same undo behavior as typing into a cell. If undo matters, save a copy before running a macro or carrying out a substantial operation that may not be reversible.

Another common misconception is that Undo is missing because the workbook was saved. Saving a workbook is not the same as clearing its undo history: a save by itself does not necessarily remove the recent actions available in the current Excel session. However, closing and reopening a workbook is not a substitute for an undo history that has already been lost. For recovery beyond recent edits, check whether the file has version history or a backup.

Undo versus version history and AutoSave

Undo and version history solve different problems. Undo is for stepping back through recent supported actions in the open workbook. Version history lets you inspect or restore an earlier saved state of a file when it is stored in a location that supports versioning, such as OneDrive or SharePoint. It can be useful if the unwanted change is no longer available in the current undo sequence.

In desktop Excel for Windows, check File > Info > Version History when version history is available for the workbook. In Excel for the web, the version-history command is available from the file’s name or file information area, depending on the interface. Review the available versions and consider the consequences before restoring one: an older version can omit changes made after that point. If you only need a few cells from an earlier state, opening or comparing a prior version may be safer than replacing the current file outright.

AutoSave is a separate feature that saves supported cloud files as you work. It does not mean that every edit is permanently irreversible, nor does it act like the Undo button. For important work, keep a copy or use the file’s supported version history rather than relying on undo as a long-term backup.

Excel on Mac and in a browser

Excel for Mac has its own toolbar and settings layout, so Windows instructions such as File > Options > Quick Access Toolbar do not apply exactly. Look for Undo and Redo in the Mac toolbar, and use Command+Z and Command+Y when the controls are not immediately visible. The menu names and customization route can differ between Mac releases, so use Excel’s current settings if you need to change which toolbar commands appear.

In Excel for the web, the buttons are part of the web interface rather than the Windows desktop QAT. If the workbook is open in a narrow browser window, toolbar controls may be condensed or placed in a different visible area. Keyboard shortcuts can save time, but the web version and desktop version do not have identical features or command availability. When an action is not offered as undoable in the web app, switching to the desktop app does not necessarily restore an undo history that has already been cleared.

Good habits when correcting spreadsheet changes

For a small mistake, Undo is usually the fastest fix. For a large or uncertain change, pause and identify what you want to recover before clicking repeatedly. Undoing too far can remove later work you meant to keep, while redoing after a new edit may no longer be possible.

  • Use the Undo list, when available, to see the recent actions before rolling back several steps.
  • Save a separate copy before running macros or making broad structural changes.
  • Use version history for an older saved state, not as a replacement for immediate undo.
  • When collaborating, avoid assuming Undo will reverse another person’s edits. It is intended to reverse actions in your own available editing sequence, not to erase a teammate’s independent work.

For example, if you accidentally overwrite a formula in one cell and notice immediately, Ctrl+Z is usually the direct response. If you discover the problem later, after more edits or after the undo sequence is unavailable, look for a prior version or a saved copy instead. The best recovery method depends on how recent the mistake is and whether the file has a suitable earlier version.

Frequently Asked Questions

Why is Redo greyed out in Excel?
Redo is usually greyed out when there is no action in the current undo sequence to redo. Undo an action first; Redo should then become available if Excel can restore that action.

What is the shortcut for Undo in Excel?
On Windows, press Ctrl+Z. On Mac, press Command+Z. You can repeat the shortcut to undo more than one recent supported action.

How do I redo something in Excel?
On Windows, press Ctrl+Y; on Mac, press Command+Y. You can also select the Redo arrow in the Quick Access Toolbar or in Excel for the web.

Why did Ctrl+Z stop working?
The action may not be undoable, or the undo history may have been cleared—for example, after running a VBA macro. If the change is older than the available history, check version history or a backup.

Can I undo a macro in Excel?
No. Running a VBA macro clears Excel’s normal undo history, and Ctrl+Z cannot reverse the macro’s changes. Save a separate copy of the workbook before running a macro you may need to roll back.

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.