How can i copy a group of cells in a row to a column?

[yargila]

I wanna copy, for example, 8 cells in a row to column C, expanding as
C1,C2,C3,C4,C5,C6,C7,C8.And i don't want to copy cells one by one..Just,
select the 8 cells in the row, apply Ctrl+C,then hightlight
C1,C2,C3,C4,C5,C6,C7,C8 and Ctrl+V...but it doesn't make sense..

 

[Norman Jones]

Hi Yargila,

Try:

Copy | Edit | PasteSpecial | Transpose

note that the copy and paste regions cannot overlap.

 

[SVC]

Copy your cells, click in C1, Paste Special and select Transpose.