Vertical to Horizontal
Try this:
Select A2:A3
From the Excel Main Menu:
<edit<copy
Select B1
<edit<paste special....Check: Transpose.....Click [ENTER]
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Terry" wrote in message
...
I have headings in one column. How do I get the headings in the horizontal
(one heading per column. For example: I have three heading in row a1,
a2,
and a3. How can I get the same headings in column A, Column B, And Column
C
with out cuting and pasting each one individually. Hope I'm making myself
clear. Thanks
--
Terry
|