View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Larry S
 
Posts: n/a
Default From Columns to Rows

Select/Copy and then under EDIT, choose Paste Special an select the
TRANSPOSE option.

"Richard" wrote in message
...

There are portions of a large spreadsheet--not the whole
spreadsheet--where
I would like to convert several cells in one column to several cells in
one
row. For example, I would like to easily cut D4, D5, D6, D7 and turn them
into E5, F5, G5, H5. Is there any way to do this without going one cell at
a
time?


--Richard