GOOGLE.SHEETS.ROW.DELETE

Premium

Experimental

Delete rows from a sheet.

Syntax

=GOOGLE.SHEETS.ROW.DELETE(Spreadsheet-Id, Sheet-Id or Sheet-Name, Start Row Index, [End Row Index])

Arguments

Name	Type	Description
Spreadsheet-Id	Text	The id of the spreadsheet to delete rows from.
Sheet-Id or Sheet-Name	Number,Text	ID or name of the sheet to delete rows from.
Start Row Index	Number	Index of the first row to delete.
End Row Index (optional)	Number	Index of the last row to delete. If not specified all remaining rows, after start row, are deleted.

Return

Type	Description
Boolean	TRUE if delete was successful.

Examples

Formula	Result	Comment
=GOOGLE.SHEETS.ROW.DELETE(B2, "S2", 5, 7)	TRUE	Deletes rows from 5 to 7 in sheet "S2" of spreadsheet with ID given in B2.