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