Custom Insert() Custom Insert()Insert the copy of the area selected or a blank area custom times or skip any cells . the blank area could be a area same to the area selected or blank rows/columns of same size. It has arguments could be specialise as "Insert content","Insert object","Shift direction","Loop","Interval","Continuous". The follow is the introduction of the arguments:
Insert content: "Copy cells" is insert a area which is copy of area selected. "Blank" is insert a blank area or blank rows/columns.
Insert object: Could be rows,columns,cells. It is limit by the area selected.
Shift direction: Shift cells right or down after insert.
1.By interval
You can refert to the effictive picture follow about "Loop","Interval","Continuous":
2.By different content of column
It could insert before the different content of specified column untile the lastest row.As the follow:
 |
 |
 |
You can use it in: 1. Insert continuous blank rows. 2.Insert a blank row every other several rows. 3. Insert a copy row every other several rows etc.4.Insert a table headline before different content.
As the follow, want to insert a blank row in different apartment, have any good way expect copy and insert one by one?
 |
|
 |
Method one:
Use the function button "Custom Insert" in the software "EXCEL speedUp Add-ins": "Custom Insert()" 
The button is under EXECL menu: "Add-ins".
Select row one,click the button "Custom Insert()", selects "Entire rows" in the "Insert object". Choose "By different content of column" and select column number "B",click "OK", done.As the follow:
As the follow, how to make sure the result expect copy and insert one by one?
|
|
|
Method one:
Use the function button "Custom Insert" in the software "EXCEL speedUp Add-ins": "Custom Insert()" The button is under EXECL menu: "Add-ins".
Select the table headline area A1:C3,click the button "Custom Insert()",selects "Copy cells" in the "Insert content". Choose "By different content of column" and select column number "B",click "OK", done.As the follow:
Want to insert a heading row every 10 rows. Have any good way to do except insert one by one?
Method one:
Use the function button "Custom Insert" in the software "EXCEL speedUp Add-ins": "Custom Insert()" The button is under EXECL menu: "Add-ins".
Selects heading row, click the button "Custom Insert()", selects "Copy cells" in the "Insert content". Enter "10" in "Interval:". Enter "1" in "Continuous:", enter the loop time in conditions, click "OK", done.
¡ïNote: The function "Custom Insert" is powerful, it can achieve various effection by set arguments. The follow picture is the introduction about the arguments of "Insert content","Insert object","Shift direction","Loop","Interval","Continuous":