| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I covert rows to columms?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I covert rows to columms?
Copy the data in the row, and then select the first destination
cell. Then go to the Edit menu, choose Paste Special, and check the Transpose option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mint" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I covert rows to columms?
Chip:
Since I have several rows, copying and pasting will take a long time. Is there any othe way? "Chip Pearson" wrote: Copy the data in the row, and then select the first destination cell. Then go to the Edit menu, choose Paste Special, and check the Transpose option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mint" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I covert rows to columms?
"Mint" wrote in message
... "Chip Pearson" wrote: Copy the data in the row, and then select the first destination cell. Then go to the Edit menu, choose Paste Special, and check the Transpose option. Chip: Since I have several rows, copying and pasting will take a long time. Is there any othe way? You can select more than one row at a time. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Linear Mode
