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

Remember that you can only use 256 columns.

Ginger wrote:

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

--

Dave Peterson