TIP 18 : Insert alternate empty lines in large data set in fraction of seconds

In this blog we will see how to see how to insert alternate blank lines in the large data set in excel sheet in fraction of seconds.

• Let us create alternate lines in below data set in excel sheet.

• To create alternate empty lines we need to create a number series in the row that is next to the last row. Easiest way is to use the auto fill feature of MS excel to generate the number series. Enter the two starting numbers 1 and 2 and select the entered number, now double click on the + icon or click on the + icon and drag till end of the row to auto fill rows with number series.

• Use the (Ctrl + Shift +  ↓(down arrow key)) to select and copy the numbers in last row. Now go to the last row of the data set and paste the number series for the next row.

• Go to the first row of the number series and select the cell, now use mouse right click and click on sort and then Sort Smallest to Largest to sort the number series.

• Once the list is sorted you will see the magic and as well the alternate empty lines in between data.

• Select the number series again in the last row and delete the series from the sheet.