Change column to row

I

Ian Morrin

Hi,

I have a list of column headings but they are all in one column, is it
possible to copy the column and paste it into a row?

Eg.

A
B
C
D
E
F
G


To
A B C D E F G

Thanks

Ian
 
J

JE McGimpsey

Ian Morrin said:
Hi,

I have a list of column headings but they are all in one column, is it
possible to copy the column and paste it into a row?

Eg.

A
B
C
D
E
F
G


To
A B C D E F G
Click to expand...

One way:

Copy A1:A7. Select your destination cell (say, B1). Choose
Edit/Paste Special, checking the Transpose checkbox. Click OK.
 
Top