RE: Excel Question: Swapping Rows
- From: "Rodney Haynie" <rhaynie@xxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 11 Mar 2011 13:32:09 -0500
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 <mailto:james.homme@xxxxxxxxxxxx>
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.
Other related posts:
