Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I invert an Excel List, means colums become rows and vv.?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I invert an Excel List, means colums become rows and vv.?
Copy and Paste Special, check Transpose
-- Kind regards, Niek Otten Microsoft MVP - Excel "tomcat" wrote in message ... | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I invert an Excel List, means colums become rows and vv.?
Firstly, please ask your question in the body of the message, not just in
the subject line. Blank messages will often be rejected or ignored. The function you want is transpose, so you either want the TRANSPOSE function, or you want to copy the data and use Edit/ Paste Special/ Transpose to copy in a transposed array. -- David Biddulph "tomcat" wrote in message ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I invert an Excel List, means colums become rows and v
Hi,
If it is a List. then convert the List to Range. Procedure 1. Do one of the following; On the Data menu, point to List and then click Convert to Range. -or- Right-click and select Convert to Range Once you convert to range the arrow will not appear to the right of list column header. 2. Select the range 3. On the Edit menu, click Copy. 4. Clik on differen cell location. 5. On the Edit menu, click Paste Special. The Paste Speial dialog is displayed. 6. Select the Transpose check box. 7. Click Ok to return to the Worksheet. Now the Column text is converted to a row. Challa Prabhu "tomcat" wrote in message ... | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are my colums in excel numbered as well as the rows | Excel Discussion (Misc queries) | |||
how can i change my sprdsht to list info from colums into rows | Excel Worksheet Functions | |||
how do I invert the rows and colums in excel? | Excel Discussion (Misc queries) | |||
How do I invert data so that the columns become rows?? | Excel Discussion (Misc queries) | |||
i want my excel colums to be rows | Excel Worksheet Functions |