Cells to columns

  • Thread starter Thread starter craiglittleperth
  • Start date Start date
C

craiglittleperth

Hi,

Easy I know, but i just can't get.

I have a list of names, A1:A100, and i want these to run across the
top of my sheet as column titles. i.e. A1:CV1

can any one help.

Thanks

Craig
 
Select A1:A100
Edit|Copy
Select B1 (can't use A1)
Edit|paste special|transpose
Delete column A if you don't need it.
 
Copy>Paste Special>Tranpose.

You can't overlap so paste to A2 then delete the original Column A.


Gord Dibben MS Excel MVP
 
Back
Top