Excel Spill Error: What It Means and How to Fix It Quickly

In Microsoft Excel for Microsoft 365, a #SPILL! error means a formula is trying to return multiple results, but Excel cannot place all of them in the worksheet. Find what is blocking the intended output range, then clear or move that content, unmerge any obstructing cells, or move the formula; the formula can then spill its results into the open cells.

What the Excel spill error means

Modern Excel formulas can return an array of results rather than a single value. Excel places the formula in one cell, called the anchor cell, and fills neighboring cells with the rest of the results. That expansion is called spilling. The anchor cell shows the formula, while the surrounding cells display its output.

#SPILL! appears when Excel cannot complete that expansion. It is usually a layout or worksheet-space problem, not proof that the formula is misspelled. The intended output area is often outlined when you select the formula cell, which can help you see where Excel wants to put the results. The exact cause may also appear beside the cell when you select its error indicator.

This behavior is part of Excel’s dynamic array feature. Functions such as FILTER, SORT, UNIQUE, and SEQUENCE can return multiple values in supported versions, including Microsoft 365. A formula that once returned one result may also spill if its logic changes or its source data grows.

How dynamic-array spilling works

Think of the formula cell as the top-left corner of a result area. If a formula returns five rows in one column, Excel needs five vertically adjacent cells, including the anchor cell. If it returns three rows and two columns, it needs a clear three-by-two rectangle. Excel adjusts the spill range as the result changes, so a formula can produce more or fewer output cells after the source data is edited.

For example, with the formula entered in D2, =SEQUENCE(5) returns the numbers 1 through 5 in D2:D6. D2 contains the formula; D3:D6 are the remaining results. If D4 already contains a value, Excel cannot fill the complete range and shows #SPILL! instead. Deleting the obstruction allows the same formula to return all five numbers.

Only the anchor cell is the formula cell. You generally cannot edit one of the other displayed results as if it were a separate formula; change the formula in the anchor or change its source data instead. This is useful to remember when a result cell appears locked or when selecting it takes you back to the formula at the top of the spill range.

Common causes of #SPILL!

The most frequent cause is one or more occupied cells in the intended spill range. A number, text entry, space, or another formula can block the output. A cell that looks empty may still contain a space or a formula returning an empty string, so visual inspection alone can be misleading. Formatting by itself, such as a fill color or border, does not normally block a spill.

Existing content: A value or formula is in one of the cells Excel needs for the array.
Merged cells: A merged cell overlaps the spill range, preventing Excel from placing results into the individual cells.
An Excel Table: Dynamic-array formulas cannot spill from within a table. A formula entered in a table column may therefore show #SPILL! when it tries to return several results.
Insufficient worksheet space: The result would extend past the last row or column. This can happen when a formula produces a very large array or refers to more source cells than intended.
A changing result size: The formula now returns more values than before, and a cell that was previously outside the spill range has become an obstruction.

These causes differ from errors such as #VALUE! or #NAME?, which generally point to an argument, data type, or function-name issue. A formula can have correct logic and still show #SPILL! because its results have nowhere to go. Conversely, removing a blocker will not fix a separate problem in the formula itself.

How to find and remove the blocker

Use this sequence in Excel for Microsoft 365 on Windows. Keep anything valuable in the suspected cells; do not clear a whole range until you know what is in it.

Select the #SPILL! cell. Look for the outlined spill range and read the message shown with the error indicator. The message may identify the type of obstruction.
Use Excel’s obstruction selection when available. Select the error indicator and choose Select Obstructing Cells. Excel will take you to the cell or cells preventing the output.
Inspect the selected cells. Check the formula bar for a value, formula, or invisible space. If the content is needed, copy it somewhere safe or move the formula to a clear area instead of deleting the content.
Clear only confirmed obstructions. On Windows, use Home > Clear > Clear Contents for selected cells when their contents can be removed. This preserves their formatting.
Check for merged cells or a table. Unmerge an obstructing cell if appropriate, or place the dynamic-array formula outside the table. Ensure the whole expected output range is clear.
Let Excel recalculate. Once the space is available, the formula should populate the spill range. If the error remains, review the message again: there may be another blocker or a separate formula issue.

On Excel for Mac, the same checks and general repair apply, although ribbon labels and the location of the error menu can differ. Excel for the web also supports many dynamic-array formulas; its menus may look different from the Windows desktop app. If you cannot find the obstruction-selection command, follow the outline and inspect the cells in the intended range directly.

A worked FILTER example

Suppose A2:A6 contains the names Ana, Ben, Cara, Dev, and Eli, while B2:B6 contains their statuses: Open, Closed, Open, Closed, and Open. With that layout, enter this formula in D2:

=FILTER(A2:B6,B2:B6="Open","No open items")

The formula returns three matching rows: Ana with Open, Cara with Open, and Eli with Open. Its output occupies D2:E4. If E3 contains an old note, the formula cannot write the second result row there and returns #SPILL!. Move or clear that note if appropriate, and the three matching records can appear. The final argument displays No open items in D2 if no rows meet the condition; it does not prevent a blocked spill range.

This example also shows why it helps to check both the height and width of a result. FILTER returns the selected rows and both columns from A:B, so it needs two output columns, not just an empty column D. If you intended to return names only, select a one-column source range in the formula. Make sure any revised range still matches the criteria range in row count.

Spill errors in tables and growing data

Excel Tables are useful for structured data because they expand as rows are added and can make formulas easier to read. However, a dynamic-array formula that needs to spill cannot do so from a cell inside a table. Put the formula in an ordinary worksheet cell outside the table, with enough clear space for its output. The formula can still refer to table data; the restriction is on where the spilling formula is entered, not on using a table as its source.

Growing source data can change the size of the output. For example, a filter that matched two records yesterday might match five after new rows are added. Leave room for the largest reasonable result, and avoid placing notes or totals directly beside a spill range if that range may grow. If the output is expected to be large, consider placing it on a separate worksheet or using a bounded source range so the formula does not process more cells than necessary.

How to avoid the error and choose an alternative

Before entering a formula that returns an array, consider where its results will land. Keep the likely spill area free of manual entries, merged cells, and table boundaries. When the formula is supposed to return a changing number of results, do not type permanent labels into cells that may later be included in that output.

If you need a result inside a table, or want a separate formula in every row, use a conventional row-by-row formula or move the dynamic-array formula outside the table. For older Excel versions that do not support a function used by the formula, use a compatible method or an Excel version that supports it; changing the spill area will not add support for a missing function. Avoid treating #SPILL! as a reason to delete the formula or convert results to values before checking what is blocking the range.

When the result is too large, narrow the source range or adjust the formula so it returns only the data needed. Entire-column references can be inefficient in some array calculations and may produce more output than expected. A smaller, deliberate range makes the intended spill area easier to inspect and reduces the chance that it will run into the worksheet edge or other content.

Frequently Asked Questions

How do I fix a #SPILL! error in Excel?
Select the error cell, inspect the outlined output area and error message, and remove or move the content blocking that area. Also check for merged cells and whether the formula is inside an Excel Table.

Can blank-looking cells cause a spill error?
Yes. A cell may appear blank while containing a space or a formula that returns an empty string. Inspect the cell or formula bar before clearing it. Formatting alone is not usually a blocker.

Can a formula in an Excel Table spill?
A dynamic-array formula cannot spill from within a table. Enter it in a normal worksheet cell outside the table, leaving enough open cells for the results.

Why does #SPILL! appear after I add data?
New source data may cause the formula to return more results, expanding its spill range into a cell that already contains content. Check the newly included area and move the conflicting content or formula.

Is #SPILL! the same as a formula error?
It is an Excel error, but it usually describes a blocked output range rather than invalid formula syntax. If the range is clear and the error persists, read the specific message and check whether the formula or function is supported in your Excel version.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.