# alternate blank row

1. ## 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. ## 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. ## 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. ## 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?

>
>
>

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

#### 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