+ Reply to Thread
Results 1 to 4 of 4

alternate blank row

  1. #1
    bayanbaru
    Guest

    alternate blank row

    I have a list of 50 names on each row. How do I add in a blank row in between
    each names?

  2. #2
    N Harkawat
    Guest

    Re: alternate blank row

    insert a column
    slect 50 cells in the new column and fill the numbers from 1 thru 50 using
    edit-fill-series
    copy this 50 numbers right below the number 50 (assuming that 50 rows below
    are blank)
    So you column has numbers 1 thru 50 and again 1thru 50
    Now select these 100 rows and sort it by numbers column
    you will see
    1 Name
    1
    2 Name
    2

    Now delete this numbered column

    "bayanbaru" <bayanbaru@discussions.microsoft.com> wrote in message
    news:C6CDE57B-60E3-48B7-B3E3-4B79B5C052A5@microsoft.com...
    >I have a list of 50 names on each row. How do I add in a blank row in
    >between
    > each names?




  3. #3
    Don Guillett
    Guest

    Re: alternate blank row

    try
    Sub insertrows()
    For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1
    Rows(i).Insert
    Next i
    End Sub


    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "bayanbaru" <bayanbaru@discussions.microsoft.com> wrote in message
    news:C6CDE57B-60E3-48B7-B3E3-4B79B5C052A5@microsoft.com...
    > I have a list of 50 names on each row. How do I add in a blank row in

    between
    > each names?




  4. #4
    bayanbaru
    Guest

    Re: alternate blank row

    very easy to use!!!! simple. thanks.

    "N Harkawat" wrote:

    > insert a column
    > slect 50 cells in the new column and fill the numbers from 1 thru 50 using
    > edit-fill-series
    > copy this 50 numbers right below the number 50 (assuming that 50 rows below
    > are blank)
    > So you column has numbers 1 thru 50 and again 1thru 50
    > Now select these 100 rows and sort it by numbers column
    > you will see
    > 1 Name
    > 1
    > 2 Name
    > 2
    >
    > Now delete this numbered column
    >
    > "bayanbaru" <bayanbaru@discussions.microsoft.com> wrote in message
    > news:C6CDE57B-60E3-48B7-B3E3-4B79B5C052A5@microsoft.com...
    > >I have a list of 50 names on each row. How do I add in a blank row in
    > >between
    > > each names?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1