# Re: Excel Question: Swapping Rows

*From*: "Bryan Schulz" <b.schulz@xxxxxxxxxxxxx>*To*: <programmingblind@xxxxxxxxxxxxx>*Date*: Fri, 11 Mar 2011 14:21:53 -0600

exactly, that's what he can't understand. Bryan Schulz ----- Original Message ----- From: Homme, James To: programmingblind@xxxxxxxxxxxxx Sent: Friday, March 11, 2011 1:58 PM Subject: RE: Excel Question: Swapping Rows Hi Rodney, What was in the row you pasted to? Thanks. Jim From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Rodney Haynie Sent: Friday, March 11, 2011 2:49 PM To: programmingblind@xxxxxxxxxxxxx Subject: RE: Excel Question: Swapping Rows I beg to differ. I tested it before I sent the email. Give me a little credit. Using JAWS 12 (in Excel 2007): Arrow to the row you want to move. Press Shift + Space (select entire row) Press Ctrl + X (Cut) Arrow to one row below where you want to move the row. Press Shift + Space (select entire row) Press Applications Key, arrow down to "Insert Cut Cells" and press enter. HDH. -R From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Bryan Schulz Sent: Friday, March 11, 2011 1:52 PM To: programmingblind@xxxxxxxxxxxxx Subject: Re: Excel Question: Swapping Rows wrong, if you do that in the middle, it will overwrite the next row and the row that was cut will be empty. Bryan Schulz ----- Original Message ----- From: Rodney Haynie To: programmingblind@xxxxxxxxxxxxx Sent: Friday, March 11, 2011 12:32 PM Subject: RE: Excel Question: Swapping Rows A little bit streamlined version: Select the row to move. Cut. Select one row below where you want the new cut row to appear. Insert Cut Cells That's it. -Rodney From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Bryan Schulz Sent: Friday, March 11, 2011 11:06 AM To: programmingblind@xxxxxxxxxxxxx Subject: Re: Excel Question: Swapping Rows hi, if this is being done somewhere in the middle and not the last two rows, you would have to do: swap row x with row y: insert a row under row y, copy row x to row z, delete row x. Bryan Schulz ----- Original Message ----- From: Homme, James To: programmingblind@xxxxxxxxxxxxx Sent: Friday, March 11, 2011 6:15 AM Subject: Excel Question: Swapping Rows Hi, I would love to be able to press one key and move a row up or down in Excel 2007. One key would swap with the row above. The other would swap with the row below. I'd like to do the same for columns. One would swap with the column to the right. The other would swap with the column to the left. I'd like to have this set of functions work for every workbook. Now for the $64 question. How difficult is this to create, and how do you do it? Thanks. Jim -------------------------------------------------------------------------- This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.

**References**:**Excel Question: Swapping Rows***From:*Homme, James

**Re: Excel Question: Swapping Rows***From:*Bryan Schulz

**RE: Excel Question: Swapping Rows***From:*Rodney Haynie

**Re: Excel Question: Swapping Rows***From:*Bryan Schulz

**RE: Excel Question: Swapping Rows***From:*Rodney Haynie

**RE: Excel Question: Swapping Rows***From:*Homme, James

## Other related posts:

- » Excel Question: Swapping Rows - Homme, James
- » Re: Excel Question: Swapping Rows - Jacques Bosch
- » RE: Excel Question: Swapping Rows - Homme, James
- » Re: Excel Question: Swapping Rows - Jared Wright
- » Re: Excel Question: Swapping Rows - Jacques Bosch
- » Re: Excel Question: Swapping Rows - Dale Leavens
- » Re: Excel Question: Swapping Rows - Dale Leavens
- » Re: Excel Question: Swapping Rows - Bryan Schulz
- » RE: Excel Question: Swapping Rows - Rodney Haynie
- » Re: Excel Question: Swapping Rows - Bryan Schulz
- » RE: Excel Question: Swapping Rows - Rodney Haynie
- » Re: Excel Question: Swapping Rows - Dale Leavens
- » Re: Excel Question: Swapping Rows - Bob Kennedy
- » RE: Excel Question: Swapping Rows - Homme, James
- » Re: Excel Question: Swapping Rows - Dale Leavens
- » RE: Excel Question: Swapping Rows - Rodney Haynie
- » RE: Excel Question: Swapping Rows - Rodney Haynie
- » RE: Excel Question: Swapping Rows - Rodney Haynie
- » Re: Excel Question: Swapping Rows - Bryan Schulz
- » Re: Excel Question: Swapping Rows - Bryan Schulz
- » Re: Excel Question: Swapping Rows - Bryan Schulz
- » Re: Excel Question: Swapping Rows - The Elf
- » RE: Excel Question: Swapping Rows - Homme, James