Excel error
Excel #SPILL! error: why it happens and how to fix it
A #SPILL! error means Excel tried to return multiple results, but something prevented those results from filling the nearby cells.
What the #SPILL! error means
Dynamic array formulas can return more than one value. Excel places those values into neighboring cells, creating a spill range.
If any cell in that spill range is blocked, merged, or unavailable, Excel cannot place the results and shows #SPILL!.
Why this error matters
Modern Excel uses dynamic arrays heavily. FILTER, UNIQUE, SORT, and SEQUENCE are powerful because they return flexible lists, but those lists need space.
Learning #SPILL! teaches you how Excel thinks about formula output, not just individual cells.
Practical examples
Blocked FILTER result
=FILTER(A2:C20,B2:B20="Open")If cells below the formula already contain values, the filtered rows cannot spill.
Generated sequence
=SEQUENCE(10)Returns ten rows. Any content in those ten cells can block the spill.
Recommended Excel functions
Common mistakes
- 01Typing a formula next to existing data without leaving room for the spill range.
- 02Using dynamic arrays inside Excel tables where spill behavior is restricted.
- 03Trying to edit only one cell inside a spill range instead of editing the original formula.
Practice
Practice this skill with interactive exercises on Calcu.
Use Calcu to practice dynamic arrays and error checking in realistic spreadsheet exercises with instant feedback.
FAQ
How do I fix a #SPILL! error?
Select the formula cell, inspect the highlighted spill range, and clear or move anything blocking the output.
Is #SPILL! always bad?
No. It usually means the formula is designed to return multiple values. The error appears only when Excel cannot place them.