Re: Excel Question: Swapping Rows

  • From: "Bryan Schulz" <b.schulz@xxxxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Fri, 11 Mar 2011 14:23:27 -0600

ok,
in that case of the insert row and paste combined in one step.

Bryan Schulz

  ----- Original Message ----- 
  From: Dale Leavens 
  To: programmingblind@xxxxxxxxxxxxx 
  Sent: Friday, March 11, 2011 2:10 PM
  Subject: Re: Excel Question: Swapping Rows


  It doesn't matter. The subsequent rows are pushed down to allow for the 
insertion.


    ----- Original Message ----- 
    From: Homme, James 
    To: programmingblind@xxxxxxxxxxxxx 
    Sent: Friday, March 11, 2011 2: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.

Other related posts: