Excel Spill Error: Causes and Fixes

To fix Excel’s #SPILL! error, select the cell showing the error, read the warning beside it, and clear or move whatever is blocking the result range. A dynamic-array formula needs room to return its results in neighboring cells; once that space is available, Excel can display the full array.

What the Spill Error Means

In Microsoft 365 Excel for Windows, formulas such as FILTER, SORT, and SEQUENCE can return several values from a single formula. Excel places the formula in one cell and fills the required neighboring cells with the other results. This behavior is called spilling, and the filled area is the spill range.

If Excel cannot put the results into that range, the formula cell displays #SPILL!. The error usually points to a layout or placement issue rather than a problem with the calculation itself. For example, a formula might correctly find six matching records but be unable to display them because one destination cell is occupied.

Spilling is different from copying a formula down a column. With a dynamic-array formula, you enter the formula once, in the top-left cell of the intended output, and Excel manages the results below or beside it. The cells in the spill range are linked to the formula cell and are not separate formulas you can edit individually.

Find the Blockage Before Changing the Formula

Start by clicking the cell with #SPILL!. Excel may show a warning icon with a description of the cause. The warning can offer an action such as selecting the obstructing cells, which is often the fastest way to identify a hidden value or stray entry. The precise menu and wording can vary slightly by Excel build.

Click the formula cell and read the error message.
Inspect the proposed spill area, including cells below and to the right of the formula.
Clear or move any content that occupies a cell in that area. Use Delete to remove a cell’s contents without removing the cell itself.
Check for merged cells, an Excel table, or a spill range that runs past the edge of the worksheet.
Recalculate or edit the formula if necessary. Excel normally updates the result as soon as the obstruction is removed.

Do not delete a whole row or column just to make room unless that change is intended: it can shift other data and formulas. If the blocked cell contains information you need, move the formula to a genuinely open area or move the existing information instead.

Common Cause: A Cell in the Spill Range Is Not Empty

The most frequent cause is something already in the destination area. That may be a number, text, a space, a formula, or even a formula that returns an empty-looking string. A cell containing a formula such as =IF(A1="","",A1) is not empty for spill purposes even when it displays nothing. Clear the cell or relocate the array formula.

Formatting alone—such as a fill color, border, or number format—does not normally block a spill. A cell can look blank and still contain a space or other value, so select it and inspect the formula bar. To check a suspected obstruction, select the cell and press Delete; if the displayed value or formula disappears, it had content. Be cautious with Clear All, which also removes formatting.

A spill range can change size when its source data changes. A formula that returned four rows yesterday may need seven today. Leave enough open space for likely results, or place the output on a separate worksheet. If other data must remain nearby, avoid relying on a fixed gap that a larger result could eventually fill.

Common Cause: Merged Cells or an Excel Table

Merged cells can prevent a dynamic array from occupying its intended range. If the warning identifies merged cells, unmerge the affected area through Home > Merge & Center > Unmerge Cells, then decide how to format the layout without merging cells across the output range. In Excel for Mac, the Home tab also contains the merge controls, though the ribbon layout can differ by version.

Dynamic-array formulas cannot spill from inside an Excel table. If the formula is in a table column, move the formula outside the table, or convert the table to a normal range if you no longer need table features. To convert a table, click inside it and choose Table Design > Convert to Range on Windows. Table Design may appear as Table on Mac, depending on the version.

You can still use table data as the source for a formula entered outside the table. For example, a formula outside the table can refer to a table column and return a dynamic array. Keep the output area outside the table and ensure no other values occupy the cells the formula needs.

Check Formula Placement, Size, and Worksheet Edges

Excel cannot spill a result beyond the worksheet’s last row or column. A vertical result beginning near the bottom of the sheet, or a horizontal result beginning near its far-right edge, may therefore return #SPILL!. Move the formula to a location with enough room in the required direction.

Some formulas produce a result whose size is difficult for Excel to determine consistently during calculation. A volatile function that changes its output size on recalculation can cause an indeterminate-size spill error. For instance, a formula using a random number to decide how many rows to generate may request a different spill range each time it recalculates. If that is the issue, use a stable row count or calculate the size in a separate, predictable step.

Large arrays can also be impractical to display. If a formula attempts to return an enormous number of cells, reduce the source range or filter the data before returning it. Avoid using entire-column references in a dynamic-array formula when a bounded range or table column will do; that can require Excel to evaluate far more cells than the task needs.

Examples of Dynamic Arrays and Their Output

For a simple test, put this formula in D2, with no content in D2:D6. It returns five numbers vertically, one in each cell from D2 through D6:

With the formula entered in D2 and D2:D6 clear, =SEQUENCE(5) returns 1, 2, 3, 4, and 5 in order. If D4 contains a value, the output cannot fit and D2 shows #SPILL!. This function is available in Microsoft 365 and Excel 2021 or later.

A filtered list is another common use. Suppose A2:A6 contains product names, B2:B6 contains their statuses, and D2 is the intended output cell. If D2:E6 is open, the following formula returns matching rows from the two source columns:

With product names in A2:A6, statuses in B2:B6, and the formula entered in D2, =FILTER(A2:B6,B2:B6="Open","No matches") returns the rows whose status is Open. If two products are marked Open, the result occupies two rows and two columns; if none are, the formula returns the text No matches in D2. An occupied cell in the required output area can cause a spill error. FILTER is available in Microsoft 365 and Excel 2021 or later.

These examples also show why deleting the formula is rarely the right first response. If the formula is valid, the main repair is usually to make the destination range available. Change the formula only when its intended output or range is wrong.

How the Spill Range Works

The formula cell is the top-left cell of the spill range and is called the anchor cell. Click that cell to view or edit the formula. The other cells in the range display results but are not independent formula cells; Excel generally prevents you from changing just one of those results. Edit the anchor formula or move the whole output instead.

Excel uses the spill reference operator, written as a hash sign after the anchor cell reference, to refer to the entire current result. For example, D2# means the complete spill range anchored at D2. This reference expands or contracts as the formula’s output changes. It is not the same thing as the #SPILL! error: the operator is a way to refer to an array, while the error reports that Excel could not place one.

Dynamic arrays are supported in Microsoft 365 and in versions such as Excel 2021 and later, but behavior and available functions depend on the Excel version. If a workbook is opened in an older version that does not support a particular dynamic-array function, the issue may appear as an unsupported function or compatibility problem rather than a spill blockage. Excel for the web supports dynamic arrays, although some interface details differ from the Windows desktop app.

Prevent Spill Errors in Shared Workbooks

Plan output areas as part of the worksheet design. Put dynamic-array formulas in dedicated sections, leave open space in the direction they expand, and keep manual notes or totals outside likely spill ranges. If the result is expected to grow, consider using a separate results sheet rather than placing the formula in a crowded report.

Use a clearly labeled output area and avoid typing notes inside it.
Prefer a table column or a bounded source range for source data, but place the spilling formula outside the table.
Check whether a formula returning blanks still occupies cells; visually empty does not always mean actually empty.
When sharing a workbook, tell collaborators which cells are generated output and should not be edited individually.
If the output is too large or changes unpredictably, narrow the input or make the expected result size stable.

On Windows, the warning icon beside an error cell is usually the quickest diagnostic. Windows keyboard shortcuts such as Delete for clearing selected cell contents work in Excel for Microsoft 365. On Mac, Delete or Backspace behavior can depend on the keyboard and version; the menu command Home > Clear > Clear Contents is a reliable way to remove content while keeping formatting. Excel for the web has similar cell-clearing options, though ribbon labels or placement may differ.

Frequently Asked Questions

How do I clear a #SPILL! error in Excel?
Click the error cell, read the warning, and clear or move content in the proposed spill range. Also check for merged cells, a formula inside a table, and insufficient space at the worksheet edge.

Why does Excel show #SPILL! when the cells look blank?
A destination cell may contain a space, an invisible character, or a formula that returns an empty string. Select the cell and inspect the formula bar; clear its contents if it is safe to do so. Formatting by itself is not usually the cause.

Can a dynamic-array formula spill inside an Excel table?
No. A formula that needs to spill cannot spill from within a table. Enter it in a suitable area outside the table, while using table columns as its source if appropriate.

Can I edit one cell in a spill range?
No, not as a separate result. Edit the formula in the anchor cell, or copy the output elsewhere as values if you need a fixed, independently editable snapshot.

Does #SPILL! mean my formula is incorrect?
Not necessarily. It often means Excel cannot place a valid array result in the required cells. Read the specific error message first; if the space is clear and the formula still fails, investigate its arguments, result size, and Excel version.

Why does a spill error return after I fix it?
The formula may now be returning more results than before, or another user or formula may have placed content in its output area. Check the current spill range again and leave enough room for the result to expand.

When to Use a Different Approach

If a worksheet layout cannot provide an open spill area, you have alternatives. Move the dynamic-array formula to a separate sheet and refer readers to that output, or use a traditional formula copied down a prepared column when a fixed-size layout is essential. In Microsoft 365, Power Query can also be useful for importing and reshaping repeatable data tasks; it is not a direct replacement for every live formula, so choose it based on whether you need a refreshable transformation or an immediately recalculating result.

The best fix is the one that preserves the data and makes the output predictable. Identify the particular obstruction first, then decide whether to clear it, relocate the formula, or redesign the output area. Once you understand that a spill formula needs an unobstructed range that can change size, most #SPILL! errors become straightforward to diagnose.

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.