GOOGLE.SHEETS.COLUMN.DELETE

Premium

Experimental

Delete columns from a sheet.

Syntax

=GOOGLE.SHEETS.COLUMN.DELETE(Spreadsheet-Id, Sheet-Id or Sheet-Name, Start Column, [End Column])

Arguments

Name	Type	Description
Spreadsheet-Id	Text	The id of the spreadsheet to delete columns from.
Sheet-Id or Sheet-Name	Number,Text	ID or name of the sheet to delete columns from.
Start Column	Text	Column to start deletion at.
End Column (optional)	Text	Last column to delete. If not specified all remaining columns, after start column, are deleted.

Return

Type	Description
Boolean	TRUE if delete was successful.

Examples

Formula	Result	Comment
=GOOGLE.SHEETS.COLUMN.DELETE(B2, "S2", "D","E")	TRUE	Deletes columns D and E in sheet S2 of spreadsheet with ID given in B2.