up vote 2 down vote favorite
share [g+] share [fb]

How do I go to a certain row in Excel 2007?

Amazingly, I can't find the answer to this simple question on Google. Ctrl+G doesn't do it. When I enter a row number under "Reference", it tells me the reference is not valid.

link|improve this question
88% accept rate
feedback

4 Answers

up vote 1 down vote accepted

If you want to go to (meaning select) a specific row, you can type, for example 10:10 in the Goto box to select row 10. You need the colon for it to work. Also, you can go to multiple rows like 10:12.

link|improve this answer
This is actually a more helpful answer than the one I originally picked. Thanks. – Jason Swett Nov 10 '10 at 19:15
feedback
up vote 5 down vote

F5 then your cell number. CTRL + g does the same thing even though you are saying it doesn't work. You have to enter an entire cell number when you use these methods, not just the row number.

link|improve this answer
feedback
up vote 4 down vote

To go to the first cell in a row just press Ctrl+G and A(row number here) so for the 5th row Ctrl+g A5 in the reference and ok.

On a further note, the reference will bring you to a specific cell. So you can do G18 if you want.

link|improve this answer
Finally, a complete answer. Thank you. – Jason Swett Nov 10 '10 at 17:11
feedback
up vote 0 down vote

Excel 2007, click in reference bar, Reference changes to a selection of the current cell reference, type your cell number and then hit enter. E.G. go to row 235, type A235, hit enter.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.