The Go To Box

F5 opens Go To. Type any address and Excel takes you there, however far away it is.

Module 1 · Getting Started · Easy · 5 Minutes read

Teleport to Any Cell

Go To is the Name Box with a memory. It keeps a list of where you have been, so you can bounce between two distant parts of a sheet.

Press F5 — The Go To box opens
Type an address — Or pick a recent one
Press Enter — You are there

How to do it

F5 ▸ type the reference ▸ OK or Ctrl + G

Go To remembers your last four jumps, so you can hop back and forth between distant areas.

Item	What it does
F5 or Ctrl + G	Opens the box
Reference field	Type any address
The list	Your recent jumps
Special button	Opens Go To Special

Go To vs Name Box

F5 ▸ type A5000 ▸ Enter

Feature	Name Box	Go To
Jump to an address	Yes	Yes
Remembers history	No	Yes
Jump back	No	Yes
Lists named ranges	Yes	Yes
Opens Go To Special	No	Yes

Result: F5

Use Go To when you are working in two distant parts of the same sheet.

Do this

Use F5 to bounce between two areas
Press F5 then Enter to jump back
Use the Special button for the powerful options

Avoid

Scrolling between two distant areas repeatedly
Not knowing Go To remembers history
Missing the Special button entirely

📌 After a jump, press F5 then Enter to return to where you came from.

Practice

Press F5 and jump to Z900.
Press F5 and Enter to jump back.
Look at the recent list in the box.

Quick quiz: You are working between row 5 and row 3000 constantly. What helps most?

Scroll each time
F5 keeps the history so you can jump back and forth
Split the window

Show answer

F5 ▸ Enter returns you to where you jumped from — Go To keeps a short history, which makes bouncing between areas painless.

🔒 Want the full interactive course? This is a free preview. The complete 39-module Excel Master Course — with hands-on lessons, quizzes and a certificate — is available inside the app.

Learn Excel the fun way
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →