I agree............select two ranges and hit the "Swap" button would be nice.

You can do it via VBA as David points out.


Gord

On Thu, 3 May 2007 11:43:03 -0700, Mark Whiteford
wrote:

I still think a swap option would be useful, but your suggestion is much
appreciated! That definitely helps improve my life with Excel.... :)
Thanks!


"Gord Dibben" wrote:

Mark

A little easier method.

Select the row or column or range then hold SHIFT key and mouse pointer on side
of range to drag to where you wish.

Two such operations will get the swap completed.


Gord Dibben MS Excel MVP


On Thu, 3 May 2007 09:11:02 -0700, Mark Whiteford <Mark
wrote:

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