Suggestion: Excel needs a swap option.
 

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

Suggestion: Excel needs a swap option.
 

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...nd.htm#movecol

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark Whiteford" <Mark wrote in message
...
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

Suggestion: Excel needs a swap option.
 

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

Suggestion: Excel needs a swap option.
 

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

Suggestion: Excel needs a swap option.
 

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

Suggestion: Excel needs a swap option.
 

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...
-----------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

Suggestion: Excel needs a swap option.
 

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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Earl Kiosterud" wrote in message ...
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.

Suggestion: Excel needs a swap option.
 

Earl

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

Takes me two steps.


Gord

On Thu, 3 May 2007 21:41:26 -0400, "Earl Kiosterud" wrote:

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.