Home / Discussions

Reply to Message

The solution to swapping
Paste Special
Transpose

More explicitly (and using the keyboard)
Highlight the range to be swapped
CTRL+c
Click in the cell to start the paste
ALT+e
s
e
Enter

Tada!
Posted by N / A
Updated - 15th Mar 2012