The #SPILL! error is unique to modern Excel (365 and 2021+) and its dynamic array formulas. It means a formula tried to output multiple results into a range, but something is blocking the space it needs. Once you understand "spilling," the fix is usually quick.
What "spilling" means
Modern Excel has dynamic arrays: a single formula can return many results that automatically "spill" into the neighboring cells. For example, =A1:A10*2 entered in one cell spills ten results down the column. This is powerful — one formula, many outputs.
The #SPILL! error appears when the formula wants to spill into cells that aren't available.
The most common cause: something's in the way
The spill range must be empty. If any cell where the results would land already contains something — a value, text, even a space — Excel can't spill, and returns #SPILL!.
The fix: look at the cells below or beside your formula where the results should appear. Find and clear whatever is blocking them. Often it's a stray value, a leftover label, or an accidental space. Once the spill range is clear, the results fill in automatically.
Excel usually shows a dashed border around the range it's trying to spill into, which helps you see exactly which cells need to be empty.
Other causes
The spill range would overlap a table. Dynamic arrays can't spill inside a formatted Excel Table (the kind created with Ctrl+T). If your formula is in or next to a Table, that's the conflict — move the formula outside the Table, or convert the Table back to a normal range.
The spill range is too big / unpredictable. A formula referencing entire columns can try to spill a million rows and error. Reference a specific range instead of a whole column.
Merged cells in the spill range. Merged cells block spilling. Unmerge any cells where the results need to go.
Not enough room. If the formula is near the edge of the sheet and can't fit its output, it errors. Move it so there's room.
How to diagnose
- Click the cell with the #SPILL! error.
- Excel typically highlights the intended spill range with a dashed outline.
- Look through that outlined range for anything that isn't empty — values, text, spaces, merged cells, or a Table boundary.
- Clear or resolve the obstruction, and the formula spills correctly.
If you don't want spilling
Occasionally you want just a single result, not a spilled array. You can use the @ operator (implicit intersection) to force a single value:
=@A1:A10
But usually the goal is to let it spill, so clearing the blockage is the right move.
The takeaway
#SPILL! means "I have multiple results but nowhere to put them." Ninety percent of the time, a cell in the spill range isn't empty — find the obstruction (Excel outlines the range for you) and clear it. It's a modern-Excel error with an almost always simple fix.