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.

(E-Mail Removed) wrote:
>
> 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

in B1:

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

copy along the first row...
Erny


<(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> 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
>

Copy>Paste Special>Tranpose.

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


Gord Dibben MS Excel MVP

On 30 May 2007 12:18:32 -0700, (E-Mail Removed) wrote:

>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

On May 30, 8:42 pm, "Erny" <Erny-removehyphensandthistext-
Me...@hotmail.com> wrote:
> in B1:
>
> =OFFSET($A$1,COL(A1),0)
>
> copy along the first row...
> Erny
>
> <craiglittlepe...@aol.com> schrieb im Newsbeitragnews:(E-Mail Removed)...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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

Craig

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

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


Gord

On Wed, 30 May 2007 12:55:29 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>Copy>Paste Special>Tranpose.
>
>You can't overlap so paste to A2 then delete the original Column A.
>
>
>Gord Dibben MS Excel MVP
>
>On 30 May 2007 12:18:32 -0700, (E-Mail Removed) wrote:
>
>>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