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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste Word 2010 0
Tree from Parent/Child Pairs 1
Copy addition formula of non-consecutive horizontal cells 2
Remove empty cells from rows that contain data 1
Divisions and formulas in a column ? for data entered in a row. 3
Help with column accumulation needed 2
Single column to multiple columns 5
Changing column reference for number of formulas at once 1

Top