CLEAR

Clear the contents of a row, including any formulas.

Syntax

CLEAR(row)

row

The number of the row to be cleared. For example: 6.

More details

Use CLEAR() in unison with UPDATE(), INSERT() and FILL() to automate tables and databases.

CLEAR(2) returns clears all the cells in row 2.