Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 10 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 ( F5) to select row 10. You need the colon for it to work. Also, you can go to multiple rows like 10:12.

share|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
this also works in OpenOffice/LibreOffice – 576i Oct 9 '13 at 12:37

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.

share|improve this answer

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.

share|improve this answer
Finally, a complete answer. Thank you. – Jason Swett Nov 10 '10 at 17:11

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .