Excel: is it possible to move column contents into a line

G

Ginger

Excel 2000: is it possible to move column contents into a line?
ie move column contents A B C to become Column headings A B C.
How is it done.
I used to be able to 'transpose' on earlier versions of Excel but am unable
to find it here.
Thanks
 
D

Dave Peterson

Copy your cells
select the new location
edit|paste special|transpose (at the bottom)

Remember that you can only use 256 columns.
 
G

ginger

Excellent! Many thanks
Ginger

Dave Peterson said:
Copy your cells
select the new location
edit|paste special|transpose (at the bottom)

Remember that you can only use 256 columns.
Click to expand...
 
Top