I'm trying to invert columns and rows in a part of my worksheet: columns should become rows and vice-versa.
How can I easily do that?
You can copy/paste special and check "Transpose" when you paste. Well explained here : http://www.ehow.com/how_13014_paste-special-command.html
Btw, if you want to do it by formula, you can use the TRANSPOSE formula. Well explained here : http://www.techonthenet.com/excel/formulas/transpose.php