Home |
Search |
Today's Posts |
#1
|
|||
|
|||
columns and rows
I have a workbook set up in excel but I want to re-arrange it so that the
columns become the rows and vice versa. There is already data stored in the workbook, so I need to make sure that it is allocated to the correct corresponding cell afterwards. Is this possible? |
#2
|
|||
|
|||
Hi
the copy / paste special - transpose function will do what you want. However, if you want to do it to large range of data i suggest you copy the data from your workbook and then edit / paste special - transpose into a new workboook ... as you can't use CUT with transpose. Notes: the numbers of columns & rows will not change - you will still be limited to 256 columns copy / edit - paste special transpose will not remember column or row widths so you'll have to set them up after Cheers JulieD "kchparse" wrote in message ... I have a workbook set up in excel but I want to re-arrange it so that the columns become the rows and vice versa. There is already data stored in the workbook, so I need to make sure that it is allocated to the correct corresponding cell afterwards. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Rows and columns | New Users to Excel | |||
sumif columns and rows | Excel Worksheet Functions |