I am trying to copy data from column A and paste it into many different
columns (B, C, D, E, etc...). Can and how do I do this?

Select all the entries in column A and use the fill handle to copy across

"Help @ Work" wrote:

I am trying to copy data from column A and paste it into many different
columns (B, C, D, E, etc...). Can and how do I do this?

Not sure I understand....

"Peter Ellis" wrote:

Select all the entries in column A and use the fill handle to copy across

"Help @ Work" wrote:

I am trying to copy data from column A and paste it into many different
columns (B, C, D, E, etc...). Can and how do I do this?

Click on the Col A header to highlight the column. The CTRL=C on the
keyboard (to copy). Then click on Col B header. While holding the mouse
button down, drag the cursor accross COl B,C,D,e, etc.. These columns should
all eb highlighted. Then CTRL=V on the keyboard will paste A into all the
highlighted columns.

"Help @ Work" wrote:

I am trying to copy data from column A and paste it into many different
columns (B, C, D, E, etc...). Can and how do I do this?

There are several different configurations you could wind up with.

Snaked 1-50 in A then 51-100 in B then 101-150 in C etc. for how many columns?

OR 1-20 across row 1 and 21-40 across row 2

Which do you want?


Gord Dibben MS Excel MVP



On Wed, 4 Oct 2006 10:17:02 -0700, Help @ Work <Help @
wrote:

I am trying to copy data from column A and paste it into many different
columns (B, C, D, E, etc...). Can and how do I do this?