Skip to main content
Version: Streamsheets 2.5

CLEARCELLS

Removes value, formula or format of cells in specified range.

Syntax

=CLEARCELLS(Range, [Type])

Arguments

NameDescription
RangeRange of cells to clear.
Type (optional)Number to specify what to clear. Note: a combination of type numbers is supported too.
Options (Defaults to 1):
1 : Clear cell value
2 : Clear cell formula

Return

TRUE on success or an error code otherwise.

Examples

FormulaResultComment
=CLEARCELLS(A1:B2)
TRUEClears the value of each cell in range A1:B1.
=CLEARCELLS(A1:B2, 1)
TRUESame as before.
=CLEARCELLS(A1:B2, 3)
TRUEClears value and formula of each cell in range A1:B1.
=CLEARCELLS(A1:B2, 7)
TRUEDeletes all cells in range A1:B1.