| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Possible to "rotate" range of cells so columns are rows and vice versa?
Is it possible to select a rectangular range of cells and then generate
a copied range of cells that is a rotation of the first range, where the columns are the rows, and vice versa? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Possible to "rotate" range of cells so columns are rows and viceversa?
Maybe
copy, then paste special and select transpose Regards, Peo Sjoblom wrote: Is it possible to select a rectangular range of cells and then generate a copied range of cells that is a rotation of the first range, where the columns are the rows, and vice versa? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Possible to "rotate" range of cells so columns are rows and vice v
Copy PasteSpecial Transpose......... Vaya con Dios, Chuck, CABGx3 " wrote: Is it possible to select a rectangular range of cells and then generate a copied range of cells that is a rotation of the first range, where the columns are the rows, and vice versa? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Possible to "rotate" range of cells so columns are rows and vice versa?
Never mind, I discovered "Paste Special" and "Transpose".
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse a spreadsheet reversing columns and rows? | Excel Worksheet Functions | |||
| How do I change rows content to column & vice versa Excel spread s | Excel Worksheet Functions | |||
| Formula to convert/transpose columns to rows (and vice versa) | Excel Worksheet Functions | |||
| columns and rows | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Linear Mode
