Protocol Online logo
Top : New Forum Archives (2009-): : Be a Geek

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

How do I change columns into rows in EXCEL?

-Inmost sun-

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


so simple, thank you!!!

-Inmost sun-

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