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..

Hi Yargila,

Try:

Copy | Edit | PasteSpecial | Transpose

note that the copy and paste regions cannot overlap.

---
Regards,
Norman



"yargila" wrote in message
...
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..

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

"yargila" wrote:

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..