Excel needs an option to easily swap two cells, rows, or columns. They
obviously would need to be the same size, number of cells, etc. It's such a
pain to do so now, as, for example, I have to create a new row, copy/paste
the data into it, copy/paste the other data over the original data, then go
back and delete the original row...

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc