| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In Excel, how do I change the rows into columns?
Current spreadsheet
a b c l m n x y z Desired spreadsheet a l x b m y c n z |
|
#2
|
|||
|
|||
|
Copy the cells, move somewhere else on the sheet or to another sheet, select
Paste Special | Transpose regards Trevor "Novice SS User" <Novice SS wrote in message ... Current spreadsheet a b c l m n x y z Desired spreadsheet a l x b m y c n z |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the columns in excel back to alpha characters? | Setting up and Configuration of Excel | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| Rows and columns | New Users to Excel | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Linear Mode
