Cells to columns

[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

 

[Dave Peterson]

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

 

[Erny]

in B1:

=OFFSET($A$1,COL(A1),0)

copy along the first row...
Erny

 

[Gord Dibben]

Copy>Paste Special>Tranpose.

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


Gord Dibben MS Excel MVP

 

[craiglittleperth]

in B1:

=OFFSET($A$1,COL(A1),0)

copy along the first row...
Erny








- Show quoted text -

Thank you so much for your help. solved a real head ache.

Craig

 

[Gord Dibben]

Typo patrol...........

Should read B1, not A2.........sheepish grin.


Gord