Skip to main content
Version: Streamsheets 2.4

CLEARCELLS

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

Syntax

=CLEARCELLS(Range [,Type])

Arguments

NameDescription
RangeRange of cells to clear.
TypeOptional. Number to specify what to clear. Note: a combination of type numbers is supported too. Defaults to 1.

Types

TypeDescription
1Clear cell value.
2Clear cell formula.
4Clear cell format. NOTE: for future version only!! Currently not supported!!

Return Value

TRUE on success or an error code otherwise.

Examples

FunctionResultComment
=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.