Copying a column without over-shooting

Z

zutalors212

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

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
 
P

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
 
Top