View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
terry terry is offline
external usenet poster
 
Posts: 193
Default Vertical to Horizontal

Thanks Ron...you've answered my question and it's been a great help and time
saver. I appreciate it.
--
Terry


"Ron Coderre" wrote:

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