Skip to main content
Photo of DeepakNess DeepakNess

Adding blank rows after each row in Google Sheets

Unproofread notes

Manually adding an empty row after each row is possible for a few rows, but won't be possible for 100s and even 1000s of rows. So here is a Google Sheets script that does this with style...

function addRows(){
  var startRow = 1;
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

for (var i=numRows; i > -1; i--) {
  sheet.insertRowsAfter(i + startRow, NUMBER_OF_ROWS_TO_ADD);
  }
}

The script auto-detects the "range" and automatically adds specified number of rows between all existing rows you have. To use, replace NUMBER_OF_ROWS_TO_ADD with the number of rows you want to add each row, for example, if you write 1 then it will create one blank rows after each row.

You can learn a bit more about doing this in this post that I wrote years ago. In fact, there's even a way to do the same with using just formula.

Comment via email