Suggestion: Excel needs a swap option.

[Guest]

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/com...f-85d62c2bcfe7&dg=microsoft.public.excel.misc

 

[David McRitchie]

Hi Mark,
You would be expected to such things in a macro.

Perhaps you simplified your example from what you actually
wanted but since it ended up as complete rows being swapped
you can do that simply with the mouse, see
Use of Mouse and keys to move, and insert rows or columns
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse

see following beginning at "move a row"
http://www.mvps.org/dmcritchie/excel/fillhand.htm#movecol

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/com...f-85d62c2bcfe7&dg=microsoft.public.excel.misc

 

[Gord Dibben]

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

 

[Guest]

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]

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

You can do it via VBA as David points out.


Gord

 

[Earl Kiosterud]

Gord,

I may have not understood you correctly, but I don't know why it takes two operations when
you drag-move with Shift to swap stuff. Seems one operation will do it.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

 

[David McRitchie]

Only if the rows or groups of rows to be swapped are adjacent to each other.

 

[Gord Dibben]

Earl

I was assuming OP wanted to move row 1 to row 10 and row 10 to row 1

Takes me two steps.


Gord