#SPILL!Excel error guide No upload

#SPILL! in Excel — Blocked dynamic array

#SPILL! means a dynamic-array formula wants to return several values but something is blocking the spill range. Clear the cells below or to the right, or move the formula to an empty area.

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

The short answer

#SPILL! means a dynamic-array formula wants to return several values but something is blocking the spill range. Clear the cells below or to the right, or move the formula to an empty area.

What it looks like

FILTER, UNIQUE, SORT or SEQUENCE returns #SPILL!
The formula works in a blank sheet but not in the report
Excel highlights the intended spill range

Why #SPILL! happens

A cell inside the spill range contains data, a formula or a merged cell.
The formula is inside an Excel Table, which does not allow dynamic-array spill.
The formula is trying to spill into a protected or hidden area.
The workbook is in an older compatibility mode.
The formula refers to its own spill range, creating a circular array.

How to fix #SPILL!

1
Clear the spill range
Select the cells Excel highlights and delete their contents. Do not delete the formula itself. Check for merged cells as well.
2
Move the formula out of the table
Dynamic arrays cannot spill inside an Excel Table. Put the formula below or beside the table, or convert the table to a normal range if appropriate.
3
Use a bounded range
Instead of referencing whole columns, reference the actual data range. This makes the spill size predictable and faster.
```
=FILTER($A$2:$C$500,$C$2:$C$500="North","No rows")
```
4
Check for a self-reference
A formula such as =FILTER(A2:A100,A2:A100>0) placed in A2 will try to overwrite its own source. Move the result to a different column.

A safer formula pattern

=FILTER($A$2:$C$500,$C$2:$C$500="North","No rows")

Returns matching rows into an empty area; clear any cells the result would occupy.

Check it in your own workbook

Paste the formula into the free browser tools to see the exact fix without uploading your file. The Error Fixer explains the code, the Formula Checker finds syntax problems, and the Formula Explainer breaks down nested logic.

Open the interactive Error Fixer Check a formula

Related functions

FILTER UNIQUE SORT SEQUENCE SORTBY

Frequently asked questions

What does #SPILL! mean in Excel?

#SPILL! means a dynamic-array formula wants to return several values but something is blocking the spill range. Clear the cells below or to the right, or move the formula to an empty area.

How do I fix #SPILL! in Excel?

Clear the spill range: Select the cells Excel highlights and delete their contents. Do not delete the formula itself. Check for merged cells as well. Move the formula out of the table: Dynamic arrays cannot spill inside an Excel Table. Put the formula below or beside the table, or convert the table to a normal range if appropriate.

Why does #SPILL! appear only in some rows?

Usually because only some rows contain the trigger: A cell inside the spill range contains data, a formula or a merged cell. The formula is inside an Excel Table, which does not allow dynamic-array spill. The formula is trying to spill into a protected or hidden area.

How can I stop #SPILL! from appearing again?

Returns matching rows into an empty area; clear any cells the result would occupy. Use this pattern as a guard: =FILTER($A$2:$C$500,$C$2:$C$500="North","No rows")

Related Excel error guides

All error codes →

#VALUE!Wrong value type#VALUE! means Excel expected a number, date or logical value but found text, an empty cell or a value from another data type. The fix is to convert the input, remove hidden characters, or guard the calculation with IFERROR.#REF!Broken cell reference#REF! means a formula points to a cell, row, column or sheet that no longer exists. It usually appears after deleting rows or columns, moving a sheet, or pasting a formula into a workbook that does not contain the referenced sheet.#N/ALookup value not found#N/A means a lookup or match function could not find the value. The value may be missing, spelled differently, stored as text instead of a number, or surrounded by spaces. Use exact-match mode and return a clear fallback.#DIV/0!Division by zero#DIV/0! appears when a formula divides by zero or by an empty cell. Excel treats a blank denominator as zero. Check the denominator, exclude blank rows, or return a controlled blank with IFERROR.

Still stuck?

Send the workbook and get the formula fixed

A human Excel expert can repair the formula, explain the cause and return a tested workbook — usually within 24 hours. Fixed quote before work starts, from $15/hr.

Get a fixed quote Ask on WhatsApp

Why #SPILL! happens

A cell inside the spill range contains data, a formula or a merged cell.

The formula is inside an Excel Table, which does not allow dynamic-array spill.

The formula is trying to spill into a protected or hidden area.

The workbook is in an older compatibility mode.

The formula refers to its own spill range, creating a circular array.

How to fix #SPILL!

Clear the spill range

Select the cells Excel highlights and delete their contents. Do not delete the formula itself. Check for merged cells as well.

Move the formula out of the table

Dynamic arrays cannot spill inside an Excel Table. Put the formula below or beside the table, or convert the table to a normal range if appropriate.

Use a bounded range

Instead of referencing whole columns, reference the actual data range. This makes the spill size predictable and faster.

=FILTER($A$2:$C$500,$C$2:$C$500="North","No rows")

Check for a self-reference

A formula such as =FILTER(A2:A100,A2:A100>0) placed in A2 will try to overwrite its own source. Move the result to a different column.

Frequently asked questions

What does #SPILL! mean in Excel?

#SPILL! means a dynamic-array formula wants to return several values but something is blocking the spill range. Clear the cells below or to the right, or move the formula to an empty area.

How do I fix #SPILL! in Excel?

Why does #SPILL! appear only in some rows?

How can I stop #SPILL! from appearing again?

Returns matching rows into an empty area; clear any cells the result would occupy. Use this pattern as a guard: =FILTER($A$2:$C$500,$C$2:$C$500="North","No rows")