+ Reply to Thread
Results 1 to 4 of 4

Excel should let you select 2 rows, right click, and SWAP them

  1. #1
    DG_Crewdson
    Guest

    Excel should let you select 2 rows, right click, and SWAP them

    Often you need to swap two rows in Excel, for example to move one item higher
    in a list. You should be able to select one row, then CTRL-click a 2nd row,
    then right-click and press SWAP, and the rows will reverse positions.
    Instead you now have to insert 2 new rows and cut & paste twice into them.

    ----------------
    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...heet.functions

  2. #2
    Jim Cone
    Guest

    Re: Excel should let you select 2 rows, right click, and SWAP them

    I am not Microsoft, however when I want to change the position of a row,
    I press the shift key and drag the row to where I want it.
    (you don't have to vote for me)
    --
    Jim Cone
    San Francisco, USA
    http://www.realezsites.com/bus/primitivesoftware


    "DG_Crewdson"
    <DGCrewdson@discussions.microsoft.com>
    wrote in message
    Often you need to swap two rows in Excel, for example to move one item higher
    in a list. You should be able to select one row, then CTRL-click a 2nd row,
    then right-click and press SWAP, and the rows will reverse positions.
    Instead you now have to insert 2 new rows and cut & paste twice into them.
    ----------------
    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.


  3. #3
    DG_Crewdson
    Guest

    Re: Excel should let you select 2 rows, right click, and SWAP them

    The drag & drop is a time-saver over cut & paste, thanks! It's still a
    2-step process that would be cool to have done in a single step!

    "Jim Cone" wrote:

    > I am not Microsoft, however when I want to change the position of a row,
    > I press the shift key and drag the row to where I want it.
    > (you don't have to vote for me)
    > --
    > Jim Cone
    > San Francisco, USA
    > http://www.realezsites.com/bus/primitivesoftware
    >
    >
    > "DG_Crewdson"
    > <DGCrewdson@discussions.microsoft.com>
    > wrote in message
    > Often you need to swap two rows in Excel, for example to move one item higher
    > in a list. You should be able to select one row, then CTRL-click a 2nd row,
    > then right-click and press SWAP, and the rows will reverse positions.
    > Instead you now have to insert 2 new rows and cut & paste twice into them.
    > ----------------
    > 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.
    >
    >


  4. #4
    Jim Cone
    Guest

    Re: Excel should let you select 2 rows, right click, and SWAP them

    I can post code that will allow you to do that if you are interested.
    I utilize the code in one of my personal add-ins.
    Select two rows/columns or two equal sized selections and run the code.
    All you would have to do is add a menu item or toolbar button and
    assign the macro to it.
    --
    Jim Cone
    San Francisco, USA
    http://www.officeletter.com/blink/specialsort.html


    "DG_Crewdson"
    <DGCrewdson@discussions.microsoft.com>
    wrote in message
    The drag & drop is a time-saver over cut & paste, thanks! It's still a
    2-step process that would be cool to have done in a single step!


    "Jim Cone" wrote:
    > I am not Microsoft, however when I want to change the position of a row,
    > I press the shift key and drag the row to where I want it.
    > (you don't have to vote for me)
    > --
    > Jim Cone
    > San Francisco, USA
    > http://www.realezsites.com/bus/primitivesoftware



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1