Google Sheets / 4 min read
Fix 'Array Result Was Not Expanded' in Google Sheets
Learn why Google Sheets cannot spill an array result and how to clear blocking cells, merged cells, and competing output ranges.
Error text: Array result was not expanded because it would overwrite data in ...
This error means the formula wants to fill multiple cells, but something is already in the way. Clear the blocked cells, remove merged cells, or move the formula to a clean column.
Check this first
- Inspect the cell named in the error tooltip first.
- Check for invisible blockers like spaces or formulas returning empty strings.
- Remove merged cells in the destination range.
- Move the formula to a blank output column if the sheet layout is crowded.
Working examples
Typical spilling formula
=FILTER(A2:C, C2:C="Open")What this message actually means
Many Google Sheets functions return more than one value. FILTER, UNIQUE, SORT, SPLIT, QUERY, and ARRAYFORMULA all expect enough empty cells to place their result.
If even one destination cell contains data, the whole result stops and Sheets shows the array expansion error instead of partially filling the range.
Fastest way to fix it
Click the formula cell, then follow the direction where the result should spill. Delete any values, formulas, or stray spaces in that destination range. If the area includes merged cells, unmerge them before testing again.
- Clear blocking cells rather than typing over the error.
- Avoid putting notes or labels directly below a spilling formula.
- Keep dynamic array outputs in their own section of the sheet.
How to avoid it later
If the sheet is shared, reserve one output zone for dynamic formulas and keep manual entries elsewhere. This reduces accidental overlaps when another editor adds notes below the formula.