Formula guide · Excel · Updated May 13, 2026
How to Fix #SPILL!
Fix #SPILL! errors in dynamic array formulas by clearing blocked cells and checking output size.
Quick Answer
#SPILL! means Excel wants to return multiple cells but something is blocking the output range.
Copyable Formula
=FILTER(A2:D20,C2:C20="Paid")Syntax
Clear the spill range or reduce the array result.Excel
Worked Example
| Cause | Fix |
|---|---|
| Blocked cell | Clear the spill range |
| Merged cells | Unmerge cells |
| Table limitation | Place formula outside the table |
Result: Once the spill range is clear, the array result appears across nearby cells.
Steps
- Select the formula cell and inspect the highlighted spill range.
- Clear anything blocking that range.
- Move the formula if the output needs more space.
Common Mistakes
- Typing values below a dynamic array output.
- Putting spilling formulas inside Excel Tables.
- Expecting one cell of output from a formula that returns multiple rows.
Excel vs Google Sheets Notes
This page is focused on Excel. If you need Google Sheets compatibility, check whether your Sheets account supports the same function or use one of the related alternatives.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.