How to Insert Multiple (x) Blank Line in each (y) Line Data Microsoft Excel

How to Insert Multiple (x) Blank Line in each (y) Line Data Excel - The main question is how to insert (insert) X blank lines in each) Y) lines of data.

First way: Using Macros
 
To facilitate such work, and Excel 2007, we need to use Visual Basic script. However, the use of macros we must be careful to execute. To avoid damage, you should make a backup file first.

Make two copies of the file so that we can safely make modifications to the script macros.

Follow these steps:

1. Open the Excel Developer tab. If not, you can display it in the following way: 

• Click the Office Button in the upper left corner of Excel
• Click Excel Options at the bottom right corner 
• On the line, check the Show Developer tab in the Ribbon

2. Klick View Code in the Controls tab 
3.  Copy the script below, and paste it on the right:

• view plainprin
•  Sub test() 
• Dim j As Long, r As Range      
•  j = InputBox("Ketik jumlah baris yang disisipkan")     
• Set r = Range("A50")     
• Do    
• Range(r.Offset(1, 0), r.Offset(j, 0)).EntireRow.Insert      
• Set r = Cells(r.Row + j + 50, 1)     
• MsgBox r.Address      
•  If r.Offset(1, 0) = "" Then Exit Do       
• Loop      
•  End Sub   

Click the Run button, it will display a Message Box that reads "Type the number of rows inserted" Type in 50 rows, and see the results. 

Second way: Using Adds-On
 
Alternatively, you can use Adds-on like Kutools for Excel 7.00
With this additional tool Kutools you much easier menginsert (X) line in every (Y) lines of data.
The tutorial will be comming soon
Hows? Easy, right? :)