To do this, right-click on the column header of the left-most column and click on Insert.
Suppose you have a dataset as shown below and you want to insert a blank between the existing rows.īelow are the steps to insert blank rows between existing rows: Since there is no direct way to add rows in between rows, the method covered in this article are workarounds to make this happen, And if you’re comfortable with VBA, then you can do this with a single click. In this tutorial, I will show you some really simple ways to insert a blank row after every row in the existing dataset (or every nth row).
