skip every other row using drag handle excel

Solved
  1. bill48nj1

    bill48nj1 New Member Bronze Member

    Joined:
    Jan 22, 2009
    Posts:
    8
    Likes Received:
    0
    Local time:
    10:40
    My System
    Loading...

    [FONT=&quot]Hi.[/FONT]
    [FONT=&quot]I’m using Office Home and Student 2007 – Excel[/FONT]
    [FONT=&quot]When I drag the fill handle down, I want to skip every other row. There is no formula in the cell, just a number. This is what I want to accomplish:[/FONT]
    [FONT=&quot] [/FONT]
    [FONT=&quot]A1 1[/FONT]
    [FONT=&quot]A2 blank[/FONT]
    [FONT=&quot]A3 2[/FONT]
    [FONT=&quot]A4 blank[/FONT]
    [FONT=&quot]A5 3[/FONT]
    [FONT=&quot]A6 blank[/FONT]
    [FONT=&quot]A7 4[/FONT]
    [FONT=&quot] [/FONT]
    [FONT=&quot]And so on.[/FONT]
    [FONT=&quot] [/FONT]
    [FONT=&quot]Thanks for your help.[/FONT]
    [FONT=&quot]bill48nj1[/FONT]
  2. Crush

    Crush Active Member

    Joined:
    Sep 28, 2008
    Posts:
    4,634
    Likes Received:
    1
    Location:
    New Jersey
    Local time:
    10:40
    My System
    Loading...

    Re: skip every other row using drag handle ex

    bill,

    Hello and welcome. The only way I know how to do this is to copy (control C) and paste (control V) the data manually into the cells you want. There isn't a way to do it via the fill handle.
  3. elpmek

    elpmek Tech Member Elite Member

    Joined:
    Feb 26, 2006
    Posts:
    2,922
    Likes Received:
    172
    Local time:
    15:40
    My System
    Loading...

    Re: skip every other row using drag handle ex

    A1 = 1
    A2 = Blank
    A3 = A1+1
    A4 = Blank


    Select A3 and A4 and copy then paste as far down the column as you wish. 5 seconds maximum, or am I missing something?
  4. bill48nj1

    bill48nj1 New Member Bronze Member

    Joined:
    Jan 22, 2009
    Posts:
    8
    Likes Received:
    0
    Local time:
    10:40
    My System
    Loading...

    Re: skip every other row using drag handle ex

    Solved.
    All I had to do is select A1, A2, A3 & A4 and drag down.
    Thanks,
    bill48nj1
  5. Crush

    Crush Active Member

    Joined:
    Sep 28, 2008
    Posts:
    4,634
    Likes Received:
    1
    Location:
    New Jersey
    Local time:
    10:40
    My System
    Loading...

    Re: skip every other row using drag handle ex

    Marked as resolved.
Similar Threads
Forum Title Date
Software Support Problems with lag/stutter/skipping in games and movies Dec 28, 2012
Software Support Audio skips when doing stuff Sep 5, 2008
Software Support [Fixed] Winamp Skipping May 11, 2008
Software Support "Everything" excludes USB stick in searches Feb 2, 2014