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.....

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.

"Ruchir" wrote:

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.....

On Thu, 29 Oct 2009 17:26:01 -0700, JLatham
wrote:

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.

"Ruchir" wrote:

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.

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

Ruchir wrote:

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.....

--

Dave Peterson

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

On Thu, 29 Oct 2009 19:39:23 -0500, Dave Peterson
wrote:

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

Ruchir wrote:

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.....

I'm thick too Gord ;)


"Gord Dibben" wrote:

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

On Thu, 29 Oct 2009 19:39:23 -0500, Dave Peterson
wrote:

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

Ruchir wrote:

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.....

.

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.)

Gord Dibben wrote:

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

On Thu, 29 Oct 2009 19:39:23 -0500, Dave Peterson
wrote:

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

Ruchir wrote:

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.....

--

Dave Peterson

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...) :-]


On Fri, 30 Oct 2009 13:49:19 -0500, Dave Peterson
wrote:

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.)

Gord Dibben wrote:

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

On Thu, 29 Oct 2009 19:39:23 -0500, Dave Peterson
wrote:

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

Ruchir wrote:

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.....