excel each add two lines of blank lines

you can go to the following address to download an add-in.casually insert a few lines every few lines.
If you do not Convenient, left-mail address, I sent you.Sub inserted every two lines of blank lines ()
Dim i%, n%
'n required to fill in the starting line for the scope of the line
n = 20
For i = 3 To n Step 3
Rows ([i] & “:” & [i]).Select
Selection.Insert Shift:= xlDown
Next i
End Sub
will more than make macro code test to excel VBA is located in (ALT + F11)
will be able to run macros, and if I could be a problem, let's discuss.F100 to the A1 such as data, G1 input 1, G2 input of 1.5, select G1 and G2, filled with down-filled stem to the G100.
G101 import 1.6, G102 import 2.6, select the G101 and G102, filled with down-filled stem to the G150 (to ensure 101-150 Acts of blank lines).
Data – sort of the main keyword for the G out, to sort the scope to include A to G out.
To delete the last G out.I come to you a assuming ..
data In the form Sheet1! Worksheet in the back of a blank sheet of A1 enter the following formula:
= IF (MOD (ROW (), 3) = 0, “”, INDEX (Sheet1! $ 1:$ 65536, (IF (MOD (ROW (), 3) = 0, “”, ROW ()-ROUNDDOWN (ROW () / 3,0))), COLUMN ()))
enter the formula after the completion of the backwards, to copy down A1 ..Can be assumed that the cell data in column A to D, E1 in the cells enter the formula:
= IF (ROW ()> COUNTA (A:A) * 3 / 2, “”, IF (ROW ()> COUNTA (A:A), (ROW ()-COUNTA (A:A)) * 2 +0.5, ROW ()))
to copy the formula down, until a blank so far.
E selected out, “copy” -> “Paste Special / value”, the value of fixed formula.
Selected A to E out, according to E ascending sort out.
Delete E out.I use the example:For example, there are 100 lines, you can find a space on the right side out in the first and second line input of 0.1 and 0.6, select the two cells, the drop-down to the (fill handle).Down automatically Filled 1.1,1.6,2.1,2.6 ……;
to fill in the number of rows you want (in this example is 100), and then after further input 1 and 2 to select the two cells, to the pull-down (Fill handle).Automatically fill down 3,4,5,6 ……
and then select the entire table to sort out the press, put out by deleting the final.Can be two lines to add One effect of the blank lines.

Note:When filling out the assurance to fill in 1,2,3,4,5,6 ….when the line where the other cell is empty Value (the only cells that have value).