Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ARRAYFORMULA (Google Sheets)
ARRAYFORMULA lets a single formula populate a whole column, instead of copying it row by row. In Excel, modern dynamic arrays spill automatically.
Topic:ARRAYFORMULA (Google Sheets)Excel
=A2:A*B2:BGoogle Sheets
=ARRAYFORMULA(A2:A * B2:B)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2:A * B2:B multiplies the two columns row by row.
- 2ARRAYFORMULA makes the result spill down the whole column.
Need a version for your data?
Try: “In Google Sheets multiply column A by column B for every row with one formula”
More on ARRAYFORMULA (Google Sheets)
See all →How-to
How to use ARRAYFORMULA to apply a formula to a whole column
Wrap any formula in ARRAYFORMULA in Google Sheets to apply it to an entire column without copying it to each row.
Error fixFix ARRAYFORMULA
ARRAYFORMULA not working in Google Sheets? Learn why it stops expanding, returns one row, or shows an error — and how to fix it.
How-toHow to split text down a whole column with ARRAYFORMULA
Use ARRAYFORMULA with SPLIT to break delimited text across an entire column in one formula in Google Sheets.