Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

4 Answers

up vote 5 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.

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
add comment

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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