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?