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

  • Thread starter Thread starter Ruchir
  • Start date Start date
R

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.....
 
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.
 
Once you have made a selection, you can use ctrl-. (control-dot/period) to
cycle between the corners of the selection.
 
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
 
I'm thick too Gord ;)


Gord Dibben said:
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



.
Click to expand...
 
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>.)
 
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 said:
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.....
Click to expand...
Click to expand...
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...) :-]
 
Back
Top