Excel #SPILL! error: what it means and how to fix it

Why a dynamic array formula can't spill its results, and how to clear the way.

The message you see
#SPILL!
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Remove stray blank rows and columns →

Why this happens

How to fix it

  1. 1Click the error and choose “Select Obstructing Cells”, then clear them.
  2. 2Unmerge cells below or to the right of the formula.
  3. 3Convert the Table to a normal range, or move the formula outside it.
  4. 4Limit references to the actual data range (A2:A500 instead of A:A).

Related guides

Still stuck? Ask SheetFix Support