You can select the cells in the column you want, copy them, and then select
the first destination cell in the row and paste special - transpose.

Hope this helps,
Miguel

"Richard" wrote:


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