Moving to end of long columns

[Bob W]

In other spreadsheets than Excel it is possible to paste
a long range of data between columns by using the
left or right column neighbour to get to the end of the
target data range.

I'll try to explain what I intend to do and I kindly ask
more experienced users to tell me a working solution:

- Imagine a column of about 60,000 rows in length
(A1 ... A60000)
- I intend to copy a cell to the empty column right of
the 60,000 rows column
- Let's presume the new cell data is already in the
clipboard
- I move to cell B1
- From B1 I move to A1 with Shift-LeftArrow
- From there I intend to move down to the last data
row of A1...A60000 - AND THIS DOES NOT WORK!

If the last step would do what I've intended (like in
MS Works), I could simply move right with
Shift-RightArrow and have my paste destination
range selected.

But Excel chooses to move to the last row of the
worksheet instead of row 60,000.

This is a nuisance and I am sure that people who
are handling large spreadsheets have found some
convenient solutions in selecting huge paste
destination ranges.

Any useful info appreciated.

 

[Bob Phillips]

Ctrl-Shift-Down Arrow works for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob W]

Ctrl-Shift-Down Arrow works for me.

That brings me all the way down to the very
last row of my worksheet (except for a column
which has already data in it).

What I usually do is to use the control arrow
keys to go to the last row of my empty
destination range and write some dummy
data into the last cell to prevent that
Ctrl-Shift-DownArrow moves me to the
bottom of my worksheet later.

But I'd like to have the same functionality as
MS Works, Open Office, etc.

 

[Niek Otten]

Another way is to double-click the Fill-handle of B1; it will fill down column B as far as there is anything in Column A.

 

[Pete_UK]

Hi Bob W,

I found the same problem when I switched from Quattro Pro many years
ago. What you can do is to mark the bottom cell in the column you want
to copy down, i.e. move into the column with your 60000 items of data
in, press <end> followed by <down arrow> and you are in the bottom row.
Move into the next column and type anything (I usually use full-stop)
then without pressing <enter> you can do <end> followed by <up arrow>
to get to the top of the column.

Otherwise, Bob's suggestion can be used.

If the item you want to copy down is in the top cell of the column (eg
B1, if your other data items are in column A), then you can just
double-click the fill handle - this is the small black square at the
bottom right corner of the cursor, and this will copy the cell contents
down for as many items as you have in column A.

Hope this helps.

Pete