View Single Post
  #2   Report Post  
Old June 29th 09, 10:00 AM posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Change from columns to rows and back

Try

Copy the listSelect a blank cellRight clickPasteSpecialSelect TransposeOK

If this post helps click Yes
---------------
Jacob Skaria


"SwEdIsH_OfFiCe_UsEr" wrote:

I have a vertical list that I want to make horizontal instead. Is there an
easy way to do this other than marking, dragging and dropping each post on a
separate column? How do I reverse the process if I instead have a long row
that I want to make into one column?