Hi
"change column and row"
The option that shows when you choose Paste Special is Transpose

--
Regards

Roger Govier


"Rasoul Khoshravan" wrote in message
...
select column, copy, select destination cell, go to speacial paste
select "change column and row" and OK. This will change place of row
and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in
one row.