H
Help @ Work
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?
columns (B, C, D, E, etc...). Can and how do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peter Ellis
Select all the entries in column A and use the fill handle to copy across
H
Help @ Work
Not sure I understand....
Peter Ellis said:Select all the entries in column A and use the fill handle to copy across
W
Wiley
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.
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.
G
Gord Dibben
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 @
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 @