FormulaCraft

ARRAYFORMULA (Google Sheets)

ARRAYFORMULA applies a formula across a whole column without dragging. Every Google Sheets ARRAYFORMULA pattern here.

4 pages · 1 reference, 2 how-to, 1 error fix

Reference

ARRAYFORMULA (Google Sheets)

Apply a formula down an entire column at once in Google Sheets.

How-to guides

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.

Excel ≠ Sheets

How 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.

Excel ≠ Sheets

Error fixes

Fix ARRAYFORMULA

ARRAYFORMULA not working in Google Sheets? Learn why it stops expanding, returns one row, or shows an error — and how to fix it.