Copying a column without over-shooting

[zutalors212@yahoo.com]

I typicall have 500 rows of data in my columns. I typically need to
manipulate the data in a quick fashion. Moreover, I must copy/paste
the data from columns A to Z, for example.

Here is my issue: I have data in column A1:a500, and I need to move
this to Z. I'd like to do so *without* including the elements of
a501:a65526.

I know the "typical" way of doing this: Scrolling all the way down to
the 500th row, and cutting/copying and pasting. This is quite time
consuming.

What I do now is click on the letter "A" as in column A, and copy/cut.
However, this copies/cuts *EVERYTHING* from that column to the
destination column. The file gets big very quickly, when this is the
case. Moreover, when I scroll down, instead of stopping at the 500th
row, it uselessly scrolls down to the 50,000th row.

[Trevor Shuttleworth]

Press F5 (GoTo) and in the Reference box type A1:A500 and press Enter. That
will select the cells you want. Press Copy. Do what you want

Regards

Trevor


<zutalors212@yahoo.com> wrote in message
news:1141243969.551496.148350@i39g2000cwa.googlegroups.com...
>I typicall have 500 rows of data in my columns. I typically need to
> manipulate the data in a quick fashion. Moreover, I must copy/paste
> the data from columns A to Z, for example.
>
> Here is my issue: I have data in column A1:a500, and I need to move
> this to Z. I'd like to do so *without* including the elements of
> a501:a65526.
>
> I know the "typical" way of doing this: Scrolling all the way down to
> the 500th row, and cutting/copying and pasting. This is quite time
> consuming.
>
> What I do now is click on the letter "A" as in column A, and copy/cut.
> However, this copies/cuts *EVERYTHING* from that column to the
> destination column. The file gets big very quickly, when this is the
> case. Moreover, when I scroll down, instead of stopping at the 500th
> row, it uselessly scrolls down to the 50,000th row.
>

[Ardus Petus]

select A1
press ctrl+shift+down arrow

HTH
--
AP

<zutalors212@yahoo.com> a écrit dans le message de
news:1141243969.551496.148350@i39g2000cwa.googlegroups.com...
> I typicall have 500 rows of data in my columns. I typically need to
> manipulate the data in a quick fashion. Moreover, I must copy/paste
> the data from columns A to Z, for example.
>
> Here is my issue: I have data in column A1:a500, and I need to move
> this to Z. I'd like to do so *without* including the elements of
> a501:a65526.
>
> I know the "typical" way of doing this: Scrolling all the way down to
> the 500th row, and cutting/copying and pasting. This is quite time
> consuming.
>
> What I do now is click on the letter "A" as in column A, and copy/cut.
> However, this copies/cuts *EVERYTHING* from that column to the
> destination column. The file gets big very quickly, when this is the
> case. Moreover, when I scroll down, instead of stopping at the 500th
> row, it uselessly scrolls down to the 50,000th row.
>

[Pete_UK]

Alternatively, select A1, hold down <shift>, press <end> followed by
<down>, release shift - this will highlight all the contiguous data
from A1 downwards. Then click <copy>, click in B1, hold down <shift>,
click in Z1, release <shift> and press <enter>.

Hope this helps.

Pete