Hi

Select your range, and copy it.

Select a cell as leftmost upper corner of new datarange (NB! old and new
datarange must NOT intersect), and then PasteSpecial with Transpose checked.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Bahareh" wrote in message
...
Hello

I have an excel sheet with some information on it which has 3 column but
lots of rows. I prefer to change order (reversing the information on
column
and rows). Is it possible?

Thanks
BHR