Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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" wrote in message ... I have a list of 50 names on each row. How do I add in a blank row in between each names? |
#3
|
|||
|
|||
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 "bayanbaru" wrote in message ... I have a list of 50 names on each row. How do I add in a blank row in between each names? |
#4
|
|||
|
|||
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" wrote in message ... I have a list of 50 names on each row. How do I add in a blank row in between each names? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
blank cell turns to 0 | New Users to Excel | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |