Product
Rows AI
Your number crunching sidekick
Integrations
Seamless connections to your tools
Support Docs
Learn how to make the most out of Rows.
Features
All-in-one spreadsheet for teams
Pricing
Templates
Community
Sign in
Sign up for free
Functions
ARRAYFORMULA
Parameter List
Syntax
ARRAYFORMULA
(
array_formula
)
array_formula
The cell or range to be extended down.
Examples
Example 1
ARRAYFORMULA(A1:C1) returns "Fill..." and cells A2..A5 are empty, B2..B5 have =1+1, C2..C5 all have similar formulas to C1.
Parameter List
Examples