How can I move to the first cell in the selection in Excel 07?

[Ruchir]

I want to select cells A80000:A83978 which I can perform a selection by
clicking on cell A2 and then press Shift+End+ down arrow key.
My question is, how can I go back to the first cell of the selection (in
this case A80000)?
Please help.....

 

[JLatham]

Since the 'first cell' in the selection is down at around row 80000, pressing
[Ctrl]+[Home] won't help (that would take you to A1). But you can type the
address you want to go to in the 'Name Box' and hit [Enter] and go right to
any cell. The name Box is the box where the address of the currently
selected cell is displayed at, just above the "A" indicator for column A in
the Formula Bar. If you don't have the formula bar displayed, use View and
select Formula Bar from the list.

 

[Dave Peterson]

Once you have made a selection, you can use ctrl-. (control-dot/period) to
cycle between the corners of the selection.

 

[Gord Dibben]

What I can't figure out is how selecting A2 then Shift + End + Downarrow
selects A80000:A83978

Am I misinterpreting something or just thick?


Gord

 

[Patrick Molloy]

I'm thick too Gord

What I can't figure out is how selecting A2 then Shift + End + Downarrow
selects A80000:A83978

Am I misinterpreting something or just thick?


Gord



.

 

[Dave Peterson]

I used ctrl-shift-end (or ctrl-shift-downarrow) to select from the current cell
to the end of the contiguous range.

(But I was answering how to select the top cell of the range--not whether the
OP's instructions worked <vbg>.)

 

[CellShocked]

Since the 'first cell' in the selection is down at around row 80000, pressing
[Ctrl]+[Home] won't help (that would take you to A1). But you can type the
address you want to go to in the 'Name Box' and hit [Enter] and go right to
any cell. The name Box is the box where the address of the currently
selected cell is displayed at, just above the "A" indicator for column A in
the Formula Bar. If you don't have the formula bar displayed, use View and
select Formula Bar from the list.

I want to select cells A80000:A83978 which I can perform a selection by
clicking on cell A2 and then press Shift+End+ down arrow key.
My question is, how can I go back to the first cell of the selection (in
this case A80000)?
Please help.....

Using the name box works, but if you want automation, you can place a
button, and assign a jump link to it where instead of hyperlinking to the
net, you hyperlink to a location in your workbook, which it allows, no
problem. Placement is the issue. You could either insert a blank column
ahead of your data, or use a cell after the data, depending on how wide
your worksheet is, it would be easy or a pain in the ass to use.

It is a shame that we cannot place worksheet specific jump links in the
tool bar of Excel that pop in whenever a workbook is opened that contains
toolbar jump links. A button bar below the formula bar would be nice for
Excel sheet builders to have and use. WITHOUT needing Visual Basic or a
macro script.

 

[CellShocked]

Does that make you "Not thick enough."? :-]

Hard to do what he said from A2.

I must be thick too. (That's what _she_ said...) :-]