change of columns into rows in EXCEL - (Apr/21/2012 )

How do I change columns into rows in EXCEL?

select the cells you want to change
copy
select the cell where you want to paste into
right click and select paste special
click 'Transpose'
click OK

so simple, thank you!!!

I cant remember these tricks, so each time I have to search the above term in the Excel help and it works.