Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Instructions to convert columns to rows Excel help are not correct
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Instructions to convert columns to rows Excel help are not correct
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Instructions to convert columns to rows Excel help are not correct
The range that you wish to paste to cannot overlap the range you are copying
from. Regards Trevor "CLR" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Instructions to convert columns to rows Excel help are not cor
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Excel - columns into rows | Excel Discussion (Misc queries) | |||
Excel - Columns into rows | New Users to Excel | |||
convert text labels to excel columns | New Users to Excel | |||
how do you group and ungroup rows or columns in new Excel? | Excel Worksheet Functions |