Instructions to convert columns to rows Excel help are not correct

[Excel 2003 Columns to rows]

I followed the Excel 2003 help instructions to convert columns to rows but
the instructions do not give me the window with paste special instructions
that the help memu specifies. What are the instructions or how do I get them.

Ken Rush

[CLR]

Select the cells in the column you wish to transpose, then Right-click and
choose COPY, then Left-click on the cell that you wish to transpose TO
(actually the leftmost cell of that range), then Right-click on that same
cell and choose PasteSpecial and on the next menu choose TRANSPOSE and OK....

hth
Vaya con Dios,
Chuck, CABGx3




"Excel 2003 Columns to rows" wrote:

> I followed the Excel 2003 help instructions to convert columns to rows but
> the instructions do not give me the window with paste special instructions
> that the help memu specifies. What are the instructions or how do I get them.
>
> Ken Rush

[Trevor Shuttleworth]

The range that you wish to paste to cannot overlap the range you are copying
from.

Regards

Trevor


"CLR" <CLR@discussions.microsoft.com> wrote in message
news:4021A36A-BD38-4F45-BC8B-52AE9BD385E3@microsoft.com...
> Select the cells in the column you wish to transpose, then Right-click and
> choose COPY, then Left-click on the cell that you wish to transpose TO
> (actually the leftmost cell of that range), then Right-click on that same
> cell and choose PasteSpecial and on the next menu choose TRANSPOSE and
> OK....
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "Excel 2003 Columns to rows" wrote:
>
>> I followed the Excel 2003 help instructions to convert columns to rows
>> but
>> the instructions do not give me the window with paste special
>> instructions
>> that the help memu specifies. What are the instructions or how do I get
>> them.
>>
>> Ken Rush

[CLR]

Good point Trevor, thanks for pointing it out.

Vaya con Dios,
Chuck, CABGx3


"Trevor Shuttleworth" wrote:

> The range that you wish to paste to cannot overlap the range you are copying
> from.
>
> Regards
>
> Trevor
>
>
> "CLR" <CLR@discussions.microsoft.com> wrote in message
> news:4021A36A-BD38-4F45-BC8B-52AE9BD385E3@microsoft.com...
> > Select the cells in the column you wish to transpose, then Right-click and
> > choose COPY, then Left-click on the cell that you wish to transpose TO
> > (actually the leftmost cell of that range), then Right-click on that same
> > cell and choose PasteSpecial and on the next menu choose TRANSPOSE and
> > OK....
> >
> > hth
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> >
> > "Excel 2003 Columns to rows" wrote:
> >
> >> I followed the Excel 2003 help instructions to convert columns to rows
> >> but
> >> the instructions do not give me the window with paste special
> >> instructions
> >> that the help memu specifies. What are the instructions or how do I get
> >> them.
> >>
> >> Ken Rush
>
>
>