2

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?

1 Answer 1

4

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

2
  • Great. The only thing is that Transpose doesn't appear in the menu unless you're copy/pasting from the same Excel instance, which I'm not doing. Workaround: Paste in the other instance, then copy from there and paste again. This time, the transpose option appears. Jun 22, 2011 at 8:22
  • Thanks for adding this tip (i forgot that point). Btw, if this does answer your question, you can accept the answer.
    – JMax
    Jun 22, 2011 at 8:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .