ShortcutdrillExcel shortcuts / navigation / Go to a cell by address
Go to a cell by address in Excel: Ctrl+G, type the address, Enter (Mac: Ctrl+G or Fn+F5)
| Windows | Ctrl+G, type the address, Enter |
|---|---|
| Mac | Ctrl+G or Fn+F5 |
| Group | navigation |
Drill: Go to a cell by address. Free, no sign-up.
What it does and when to use it
Ctrl+G (or F5) opens the Go To box. Type an address such as H250 or a range such as B2:F40 and press Enter. The box also lists named ranges and remembers where you came from.
The common mistake
Typing in the Name Box instead, which also works but needs the mouse to reach. Ctrl+G keeps your hands on the keys.
Related shortcuts
- Jump to a named range F5, pick the name, Enter
- 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
- The printable cheat sheet
Questions
What is the difference between F5 and Ctrl+G?
None; both open Go To. On a Mac laptop F5 needs Fn, so Ctrl+G is easier.
Can Go To select a range?
Yes. Type B2:F40 and press Enter and the whole range is selected, which is faster than Shift+Arrow for a range you can name.
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