I have a collection of column headers and simply want to move them into a
single Row up and down.
thanks
I have a collection of column headers and simply want to move them into a
single Row up and down.
thanks
Hi
select your headers and copy them
choose a blank cell in the row you want to paste them into and choose
edit / paste special - transpose - OK
delete the original range if you want to
cheers
JulieD
"shepbinker" <[email protected]> wrote in message
news:[email protected]...
>I have a collection of column headers and simply want to move them into a
> single Row up and down.
>
> thanks
shep
They are already in a row(sideways).
What you want is for them to be in one column(up and down).
Edit>Copy.
Select a column and Edit>Paste Special>Transpose>OK>Esc.
Note: you cannot paste to any part of the original row.
Gord Dibben Excel MVP
On Thu, 3 Feb 2005 08:55:06 -0800, "shepbinker"
<[email protected]> wrote:
>I have a collection of column headers and simply want to move them into a
>single Row up and down.
>
>thanks
Thanks JulieD this did help...I knew it was simple just couldn't think of
Transpose when I needed too. :-)
"JulieD" wrote:
> Hi
>
> select your headers and copy them
> choose a blank cell in the row you want to paste them into and choose
> edit / paste special - transpose - OK
>
> delete the original range if you want to
>
> cheers
> JulieD
>
>
> "shepbinker" <[email protected]> wrote in message
> news:[email protected]...
> >I have a collection of column headers and simply want to move them into a
> > single Row up and down.
> >
> > thanks
>
>
>
Thanks very much.... I had done it before but was just drawing a blank at a
time I needed it.
"Gord Dibben" wrote:
> shep
>
> They are already in a row(sideways).
>
> What you want is for them to be in one column(up and down).
>
> Edit>Copy.
>
> Select a column and Edit>Paste Special>Transpose>OK>Esc.
>
> Note: you cannot paste to any part of the original row.
>
>
> Gord Dibben Excel MVP
>
> On Thu, 3 Feb 2005 08:55:06 -0800, "shepbinker"
> <[email protected]> wrote:
>
> >I have a collection of column headers and simply want to move them into a
> >single Row up and down.
> >
> >thanks
>
>
you're welcome
"shepbink" <[email protected]> wrote in message
news:[email protected]...
> Thanks JulieD this did help...I knew it was simple just couldn't think of
> Transpose when I needed too. :-)
>
> "JulieD" wrote:
>
>> Hi
>>
>> select your headers and copy them
>> choose a blank cell in the row you want to paste them into and choose
>> edit / paste special - transpose - OK
>>
>> delete the original range if you want to
>>
>> cheers
>> JulieD
>>
>>
>> "shepbinker" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have a collection of column headers and simply want to move them into
>> >a
>> > single Row up and down.
>> >
>> > thanks
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks