ARRAYFORMULA (Google Sheets)
Apply a formula down an entire column at once in 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.
Excel
=A2:A*B2:BGoogle Sheets
=ARRAYFORMULA(A2:A * B2:B)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”