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.

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.

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.

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.