ShortcutdrillExcel shortcuts / navigation / Jump to a named range
Jump to a named range in Excel: F5, pick the name, Enter (Mac: Fn+F5)
| Windows | F5, pick the name, Enter |
|---|---|
| Mac | Fn+F5 |
| Group | navigation |
Drill: Go to a named range. Pro drill. Twenty-five drills are free.
What it does and when to use it
The Go To box lists every defined name. Type the name or pick it from the list and the whole range is selected. Names survive inserted rows, so the jump keeps working as the model grows.
The common mistake
Typing the name with the wrong case or a space. Names are not case sensitive but cannot contain spaces; use an underscore.
Related shortcuts
- Jump to the cells a formula uses Ctrl+[
- Return to where you came from F5, Enter
- 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
- The printable cheat sheet
Questions
How do I see all the names in a workbook?
Ctrl+F3 opens the Name Manager. The Go To box shows the same list and jumps to one.
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