Rows will be joining Superhuman.
Learn more
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
Rows will be joining Superhuman
Learn more
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