# Re: Excel Question: Swapping Rows

*From*: Jared Wright <wright.jaredm@xxxxxxxxx>*To*: programmingblind@xxxxxxxxxxxxx*Date*: Fri, 11 Mar 2011 07:35:15 -0500

`You could use Excel's built-in ability to move and copy rows/columns.
``Move column A to column X at the end of the spreadsheet, move Column B
``to column A, move column X to column B. I'm sure you can automate this
``down to one keypress if you want to dig into VB for applications a bit
``and tie those actions to a hotkey.
`

http://office.microsoft.com/en-us/excel-help/move-rows-or-columns-HP005201464.aspx On 3/11/2011 7:15 AM, Homme, James wrote:

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.

__________

`View the list's information and change your settings at`

`http://www.freelists.org/list/programmingblind`

**References**:**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