Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Switching rows and columns
Hello wise ones, how do you make everthying in column A format to Row 1, and
everything in Row 1 format to column A? Basically just switch them around. |
#2
|
|||
|
|||
Have a look in help index for TRANSPOSE
-- Don Guillett SalesAid Software "Brurobiney" wrote in message ... Hello wise ones, how do you make everthying in column A format to Row 1, and everything in Row 1 format to column A? Basically just switch them around. |
#3
|
|||
|
|||
Look up TRANSPOSE Worksheet Function in your Excel Help.
The example transposes a single row to a single column More impressive if not limited to a single row or column but the technique is the same. Might be a good time to mention Peter Noneley's workbook example which can be downloaded from Ron de Bruin's home page http://www.rondebruin.nl/id.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Brurobiney" wrote in message ... Hello wise ones, how do you make everthying in column A format to Row 1, and everything in Row 1 format to column A? Basically just switch them around. |
#4
|
|||
|
|||
could also copy then click edit/paste special and select transpose.
"Brurobiney" wrote: Hello wise ones, how do you make everthying in column A format to Row 1, and everything in Row 1 format to column A? Basically just switch them around. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions |