Go to a specfiic row

G

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
 
A

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
 
G

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
 
G

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
 
H

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
 
Top