AI Hub / AI posts
AI · 1 min read

ARRAYFORMULA

ARRAYFORMULA function in Google Sheets: Spills array results across cells.

November 5, 2026
Google Sheets functions / Google
Google function · Google Sheets

ARRAYFORMULA function

Spills array results across cells.

Availability

PlatformStatus
ExcelNot listed
Google SheetsListed
On Excel: use Dynamic arrays. Modern Excel spills array results without a wrapper.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.