How can I move to the first cell in the selection in Excel..

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
<petersod.TakeThisOut@verizonXSPAM.net> 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
> <petersod.RemoveThis@verizonXSPAM.net> 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
> <petersod DeleteThis @verizonXSPAM.net> 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

On Thu, 29 Oct 2009 17:26:01 -0700, JLatham
<JLatham.TakeThisOut@discussions.microsoft.com> 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.

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
<petersod DeleteThis @verizonXSPAM.net> 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
>> <petersod DeleteThis @verizonXSPAM.net> 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.....