Apply a formula to an entire range at once so it auto-fills down without copying.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
ARRAYFORMULA(array_formula)ARRAYFORMULA makes a single formula operate across whole columns, so new rows are covered automatically. It's a Google Sheets staple with no direct Excel equivalent (modern Excel spills natively instead).
=ARRAYFORMULA(A2:A*B2:B)Result: Whole-column product
Multiplies each row of A by B down the entire column.
No — modern Excel (365/2021) spills array results automatically without it.