ARRAYFORMULA

Parameter List

Syntax
ARRAYFORMULA(array_formula)
array_formula

The cell or range to be extended down.

Examples

ARRAYFORMULA(A1:C1) returns "Fill..." and cells A2..A5 are empty, B2..B5 have =1+1, C2..C5 all have similar formulas to C1.