You need to reverse a recent action in your Excel workbook, like deleting data or applying a format. The Undo and Redo commands are built-in features for correcting mistakes. This article explains how to use the keyboard shortcuts, the Quick Access Toolbar buttons, and the command history.
Key Takeaways: Undo and Redo in Excel
- Ctrl+Z (Undo): Reverses your last action, such as typing, deleting cells, or changing a formula.
- Ctrl+Y (Redo): Reapplies an action you just undid, restoring the change.
- Undo button on Quick Access Toolbar: Click the arrow next to it to see and select from a list of recent actions to reverse multiple steps at once.
Understanding Excel’s Undo and Redo Features
The Undo command tracks nearly every edit you make in a workbook session. It creates a temporary history of actions like data entry, formatting, inserting rows, and sorting. The Redo command only becomes available immediately after using Undo. It lets you step forward through the actions you just stepped back through. These features are essential for non-destructive editing, allowing you to experiment without permanent consequences.
A key point is that the Undo history is cleared when you save the workbook. After saving, you cannot undo actions performed before the save point. The history is also specific to each open Excel window. Actions in one workbook do not affect the Undo stack in another. Some major actions, like saving the file itself or running certain macros, cannot be undone.
Steps to Undo and Redo Actions
You can reverse or repeat actions using keyboard shortcuts, mouse clicks, or touch gestures. The following methods work in Excel for Windows, Mac, and the web version.
Using Keyboard Shortcuts
- Press Ctrl+Z to undo
Immediately after making a change, press and hold the Ctrl key and tap the Z key. This reverses your most recent action. You can press Ctrl+Z multiple times to step backward through your action history. - Press Ctrl+Y to redo
After using Undo, press and hold the Ctrl key and tap the Y key. This reapplies the last action you undid. You can press Ctrl+Y multiple times to step forward through the actions you previously reversed.
Using the Quick Access Toolbar
- Locate the toolbar
Find the Quick Access Toolbar in the top-left corner of the Excel window, above the File tab. It contains the Undo and Redo buttons by default. - Click the Undo button
Click the curved arrow pointing left to undo the last action. Click it repeatedly to undo multiple steps in sequence. - Use the Undo drop-down list
Click the small arrow to the right of the Undo button. A list of your recent actions appears. Click any action in the list to undo all steps back to that point. - Click the Redo button
Click the curved arrow pointing right to redo an action you just undid. This button is only active immediately after using Undo.
Common Mistakes and Limitations
Users often encounter specific limits or confusing behavior with Undo and Redo. Knowing these prevents frustration when the commands do not work as expected.
Undo History Clears After Saving
Saving your workbook clears the entire Undo history. You cannot undo any actions performed before the save. This is a permanent limitation. To preserve your ability to undo, complete a series of edits before saving the file.
Redo is Not Available
The Redo command only works right after an Undo. If you perform any new action after undoing, the Redo stack is cleared. The Ctrl+Y shortcut or Redo button will then perform a repeat function on the new action instead.
Some Actions Cannot Be Undone
Major structural changes often cannot be reversed. Examples include deleting a worksheet, saving a file, or running a macro that modifies many cells. Excel typically shows a warning message before such irreversible actions.
Keyboard Shortcut vs. Toolbar Button Comparison
| Item | Keyboard Shortcut (Ctrl+Z / Ctrl+Y) | Quick Access Toolbar Button |
|---|---|---|
| Speed | Fastest method, hands stay on keyboard | Requires moving hand to mouse |
| Multiple Undo | Must press repeatedly | Drop-down list allows jumping back multiple steps at once |
| Visibility | No visual history | Drop-down shows list of recent actions |
| Availability | Always available unless command is disabled | Can be customized or removed from toolbar |
You can now efficiently correct mistakes using Ctrl+Z and Ctrl+Y. Use the Undo drop-down list on the Quick Access Toolbar to reverse many steps at once. For advanced control, explore the Repeat command by pressing F4 to reapply the last single action, even if it was not just undone.