Delete multiple rows

Here is a tip how to delete multiple rows.

 

Source code

function deleteRows() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getActiveSheet();

  sh.deleteRows(4, 3);
}

  

Format

SheetObject.deleteRows(rowPosition, howMany)

  

Parameters

rowPosition … The target row’s number.

howMany … This is the number of rows to be deleted.

  

Responses

None

Leave a Comment