ShortcutdrillExcel shortcuts / navigation / Return to where you came from
Return to where you came from in Excel: F5, Enter (Mac: Fn+F5, Enter)
| Windows | F5, Enter |
|---|---|
| Mac | Fn+F5, Enter |
| Group | navigation |
Drill: And jump back. Pro drill. Twenty-five drills are free.
What it does and when to use it
After a Go To or a precedent trace, the Go To box has your previous location pre-filled. F5 then Enter bounces you straight back. It makes auditing a chain of formulas a rhythm: Ctrl+[, look, F5 Enter.
The common mistake
Using Ctrl+Z to go back, which undoes edits rather than moves.
Related shortcuts
- Jump to the cells that use this one Ctrl+]
- Move to the next sheet Ctrl+Page Down
- Find the last cell on a wide sheet Ctrl+End
- Back to the top left from anywhere Ctrl+Home
- Select every error cell Ctrl+G, Alt+S, K, Enter
- The printable cheat sheet
Questions
Does Go To remember more than one location?
The reference box holds the last one, and the list below it shows recent locations you can pick.
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