Learn › Excel › Go to a cell or range
Excel Go To shortcut: Ctrl + G
Type a cell address and jump straight there, or type a range to select it.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
Laptops with an Fn key: the F keys (F2, F4, F5, F11...) usually need Fn pressed together with them, for example Fn + F4. If Fn Lock is on, they work without Fn.
What it does
Ctrl + G opens the Go To box. Type a cell address such as H30 and press Enter, and the sheet scrolls there at once. Type a range such as B2:D8 and Excel selects the whole range, ready to copy, format or fill.
When to use it
Use it in a long sheet where scrolling takes too long, or to select an exact block without dragging the mouse. It also takes you to a cell on another sheet, if you type the sheet name first.
How to do it
- Press Ctrl + G. The Go To box opens.
- Type a cell, such as H30, or a range, such as B2:D8.
- Press Enter. Excel jumps to the cell or selects the whole range.
A quick example
In a sales table with 40 rows, press Ctrl + G, type H30 and press Enter: the sheet scrolls to H30 at once. Press Ctrl + G again, press Ctrl + A, type B2:D8 and press Enter: the whole block B2:D8 is selected.
Ctrl + G, the Name Box and Ctrl + Arrow
The Name Box, to the left of the formula bar, does the same job: click it, type an address and press Enter. Ctrl + G is faster because your hands stay on the keyboard. Use Ctrl + Arrow when you want to jump to the edge of your data instead of to a known address.
Shortcuts mentioned on this page, with video:
Keys on other keyboards
In some language versions of Excel, Ctrl + G does something else, because the letters follow the local words. F5 opens the same Go To box in every version.
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- A red message says the format is wrong: the old entry stayed in the box and your new address was added to it. Press Ctrl + A inside the box and type again.
- Excel does not accept the address: a cell is a column letter and a row number, like H30, and a range has a colon in the middle, like B2:D8.
- You want another sheet: type the sheet name first, like Sheet2!A1.
- On a Mac the shortcut is Control + G.
Quick answers
What is the shortcut for Go To in Excel?
Press Ctrl + G. A Go To box opens where you type a cell or a range, and Enter takes you there.
How do I select a range by typing it?
Press Ctrl + G, type the range, like B2:D8, and press Enter. The whole range is selected.
How do I go to a cell on another sheet?
Press Ctrl + G, type the sheet name, an exclamation mark and the cell, like Sheet2!A1, and press Enter.
What is the difference between Go To and the Name Box?
They do the same job. The Name Box is one click away, and Ctrl + G keeps your hands on the keyboard.

