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

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

Hi Richard,

Try:

Select the D4:D7 range
Edit | Copy
Select E5
Edit | PasteSpecial | Transpose


---
Regards,
Norman



"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

Copy the cells to the clipboard and then select Paste Special and check
Transpose.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=544409

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