ShortcutdrillExcel shortcuts / editing / Undo
Undo in Excel: Ctrl+Z (Mac: Cmd+Z)
What it does and when to use it
Ctrl+Z undoes the last action, and keeps undoing with each press, up to 100 steps. Ctrl+Y redoes. It is the shortcut that makes every other one safe to try.
The common mistake
Undoing past the point you wanted and not noticing. Watch the sheet, or press Ctrl+Y to step forward again.
Related shortcuts
- AutoSum below a column Alt+=
- AutoSum across a row Alt+=
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- The printable cheat sheet
Questions
Can I undo after saving?
Yes, within the same session. Closing the workbook clears the undo history.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill