Go to a specfiic row

[Guest]

Help, I haven't worked with Excel in a while and I've gone brain-dead today.


I'm working with some huge spreadsheets, 25,000+ rows. Rather than scrolling
down, how do I go directly to row "xxx"?

Thanks,

Phideaux

 

[Andy Pope]

Hi,

You could use the Go To dialog.
CTRL+G and the enter Axxx , where xxx is the row.

or enter the cell address in the namebox, which is next to the formula bar.

Cheers
Andy

 

[Gord Dibben]

Phideaux

Type the address(Axxx) in the Name Box and hit <enter> key.

Name Box is located at left side of formula bar.


Gord Dibben Excel MVP

 

[Gord Dibben]

Phideaux

Type the address(Axxx) in the Name Box and hit <enter> key.

Name Box is located at left side of formula bar.


Gord Dibben Excel MVP

 

[Harald Staff]

Hi Phideaux

There's an address field above the row indicators. It displays the address
of your selection. Enter "Axxx" (no quotes -and no x'es either, use digits)
and Enter into it and the eagle has landed.

HTH. Best wishes Harald

 

[Guest]

Thanks guys, got it.