| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change columns going from left to right to rows going up.
I have a large worksheet with over 200 columns that I want to change the
orientation so that the column headings are rows. For example: B1 becomes A2; C1 becomes A3, etc. Can anyone help? |
|
#2
|
|||
|
|||
|
You can use a help sheet and just copy the data, select A2 in the new sheet
and do editpaste special and select transpose note that if you have more than 256 rows in any of the columns (b1, ci etc) than it won't work since excel has only 256 columns Regards, Peo Sjoblom "Steve" wrote: I have a large worksheet with over 200 columns that I want to change the orientation so that the column headings are rows. For example: B1 becomes A2; C1 becomes A3, etc. Can anyone help? |
|
#3
|
|||
|
|||
|
Steve,
Copy the data, find another place (even if temporary, you can't use the same place), Paste Special - Transpose. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Steve" wrote in message ... I have a large worksheet with over 200 columns that I want to change the orientation so that the column headings are rows. For example: B1 becomes A2; C1 becomes A3, etc. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change rows to columns and vise versa | New Users to Excel | |||
| Finding the Average Change in Two Columns | Excel Worksheet Functions | |||
| How do I change the names of the cells or columns from "A" to wha. | New Users to Excel | |||
| how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
| Change number of columns mid page? | Excel Worksheet Functions | |||
Linear Mode
