#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    163
    Rep Power
    27

    Select alternate rows in Excel


    Is it possible to automatically copy only alternate rows (A1, A3, A5,...A51...) and paste it in another column?
  2. #2
  3. They're coming to take me away

    Join Date
    Jan 2005
    Location
    Florida
    Posts
    5,105
    Rep Power
    5049
    Originally Posted by gaanee
    Is it possible to automatically copy only alternate rows (A1, A3, A5,...A51...) and paste it in another column?
    One way is to take a blank column, for example D. Type:
    =MOD(ROW(A5),2)=0

    into all of the rows you have used... in your example, you have up to A51, so copy that command down to A51.

    Then, still in that column, apply an Autofilter:
    Data --> Filter --> Autofilter

    From the drop down box, select True (or False), and it will show all of the odd (or even) column data. From there you can highlight the data and copy it to where you need it to go. Then you can disable Autofilter:
    Data --> Filter --> Autofilter

    Comments on this post

    • Axweildr agrees
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    163
    Rep Power
    27
    Thanks Hiker.
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Posts
    2
    Rep Power
    0

    ASAP Utilities


    Originally Posted by gaanee
    Is it possible to automatically copy only alternate rows (A1, A3, A5,...A51...) and paste it in another column?
    Try ASAP Utilities (search by name to find the site as I am not allowed to paste URLs) for one click options for this and many more useful options. It is free for personal use.

    You can also use Go To (F5) ==> Special options for achieving what you want to do...
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Posts
    24
    Rep Power
    0
    Wht about PowerUtils ???Is that same?
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0

    Copy/Fill to Alternate Rows/Columns in Excel


    Type the formula to be copied or to fill - 1 (as an example) in the first cell.
    Make sure second cell is empty.
    Now select these two cells but - this is important - don't use the mouse/drag - use the {shift)}{cursor down} keys instead.
    Now switch to the mouse and drag down over the range to be copied.
    You should now have the data copied in alternate rows.
    Works equally well for other sequences or columns

IMN logo majestic logo threadwatch logo seochat tools logo