| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |||
Hybrid Mode
