Excel should allow exchange between cells
 

I often want to exchange three cells of information on one row with three
cells on another row. You could transpose the information by highlighting the
first selection, hitting the command and then highlighting the second
selection.

----------------
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...et.f unctions