Go to specific row number in excel

Question

Is there a way in Excel to go to a specific row number? For example I need to find an alternate way to not have to scroll but rather can immediately go to row # 3000

score 130 · Accepted Answer · answered Jun 23 '12 at 00:58

130

There is a little box next to the formula bar in your toolbar, if you are in the first cell and row it should read A1, so to go to row 3000 type A3000 and press enter

answered Jun 23 '12 at 00:58

wilson · Answer 2 · 2018-04-04T06:58:34.413

66

Ctrl-G

CtrlG > Specify row (38:38), column (C:D), cell (A1) or range (Range1) > Enter

Of course, if you want to go to row 38, you can type A38 instead of 38:38 for fewer keystrokes.

Note: CtrlG is the hotkey of Go To

Little box

Alternatively, the little box at the left of the formula bar is another option. Similarly, you can specify row, column, cell or range there.

edited Apr 04 '18 at 06:58

answered Jun 23 '12 at 02:43

wilson

5,222

score 7 · Answer 3 · answered Nov 07 '19 at 15:53

7

Ctrl + G
A[row number] Eg: A1245

answered Nov 07 '19 at 15:53

Andrew Koper

171

Go to specific row number in excel

3 Answers3

Ctrl-G

Little box