Go to a specfiic row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 18 Jan 2005 21:54 GMT

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

Reply to this Message

Andy Pope - 18 Jan 2005 22:01 GMT

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

> Help, I haven't worked with Excel in a while and I've gone brain-dead today.
> :-)
[quoted text clipped - 5 lines]
>
> Phideaux

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Gord Dibben - 18 Jan 2005 22:02 GMT

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

>Help, I haven't worked with Excel in a while and I've gone brain-dead today.
>:-)
[quoted text clipped - 5 lines]
>
>Phideaux

Reply to this Message

Gord Dibben - 18 Jan 2005 22:03 GMT

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

>Help, I haven't worked with Excel in a while and I've gone brain-dead today.
>:-)
[quoted text clipped - 5 lines]
>
>Phideaux

Reply to this Message

Harald Staff - 18 Jan 2005 22:04 GMT

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.

> Help, I haven't worked with Excel in a while and I've gone brain-dead today.
> :-)
[quoted text clipped - 5 lines]
>
> Phideaux

Reply to this Message

- 18 Jan 2005 22:05 GMT

> Help, I haven't worked with Excel in a while and I've gone brain-dead today.
> :-)
[quoted text clipped - 5 lines]
>
> Phideaux

Reply to this Message