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? |
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? |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com