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.
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
[email protected]
"Brurobiney" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks