COLUMNDEFAULT function

Description

COLUMNDEFAULT(column) returns the current default value (or formula) for a column, if any is set.

Column numbers are zero-based. The first column is column 0.

The default value of a column is a value that is applied to empty cells or cells for which no value has been entered in that column.

See Format spreadsheet, Column tab, Default value.

See also

• Information functions
• Format spreadsheet