Excel Spill Error: Why It Keeps Happening and How to Fix It

You keep getting a spill error in Excel when a formula is trying to return multiple results but Excel cannot place them in the cells it needs. The quickest fix is to select the #SPILL! cell, inspect the outlined spill range, and remove or move whatever is blocking that range; if the formula is inside an Excel table or the range includes merged cells, change the layout or formula instead.

What a spill error means

In Microsoft 365 Excel, many formulas can return an array of results rather than a single value. Excel places the first result in the formula cell and “spills” the remaining results into neighboring cells. Functions such as FILTER, SORT, UNIQUE, and SEQUENCE are common examples. The formula is entered once, in the upper-left cell of the output area, and the other cells display its results automatically.

The #SPILL! error means Excel cannot create that output range as currently arranged. It does not necessarily mean the formula’s logic is wrong. The formula may be valid, but another value, a merged cell, a table boundary, or a very large result can prevent Excel from displaying its output. A spill range can also change size as the source data changes, which explains why a formula that worked yesterday may fail after an edit or a new import.

For example, with cell B3 selected and available cells below it, =SEQUENCE(5) returns 1, 2, 3, 4, and 5 vertically in B3:B7. If B6 contains a note, Excel cannot display the complete result and shows #SPILL! in B3. The formula’s starting cell is called the anchor cell; the blocked cells belong to its intended spill range.

Why the error keeps coming back

A spill error often returns because the obstruction is being recreated, not because Excel is randomly failing. A refreshed report may put data back into the output area; a copied formula may again overlap an existing list; or a changing source range may produce more results than it did before. If the formula is in a shared workbook, another person’s edits can also place content in the range.

Sometimes the blocking cell is not visually obvious. A cell containing a space, a formula that displays an empty string, or a value far down the expected output range can still occupy a cell. Formatting alone, such as a fill color or border, does not normally block a spill. The important distinction is whether a cell contains something, not whether it looks empty.

Also check whether the formula was moved or copied. Dynamic-array formulas do not need to be copied down one row at a time: the anchor formula creates the results. Copying it into cells that should be part of its output can create overlap or leave multiple formulas competing for the same area.

How to identify the exact cause

Start with Excel’s error information rather than clearing cells at random. Select the cell showing #SPILL!. Excel usually outlines the intended spill range with a dashed border. Select the warning icon beside the error and, when available, choose Select Obstructing Cells. Excel will select the cell or cells preventing the result from appearing.

Click the #SPILL! anchor cell and read the message shown with the warning icon. The message often names the specific problem, such as a nonblank cell or a merged cell.
Look across the outlined range, including rows and columns that are outside the visible portion of the window. Scroll to inspect the full boundary if necessary.
Check the formula bar for the selected blocking cell. A formula returning an empty-looking result, a stray space, or an old value may be the cause.
Decide whether the blocker is important data. Move it, move the formula, or adjust the formula’s output; clear a cell only if its contents are genuinely safe to remove.

If Excel does not identify one obvious obstruction, read the exact error message and check the special cases below. Some spill errors arise from the formula’s location or output size, so deleting a nearby value will not solve them.

Common cause: cells in the spill range are not blank

The most frequent cause is content in one or more destination cells. This can be a number, text, a formula, or a single space. A cell containing a formula that returns an empty string may look blank on the worksheet but still interfere with a spill. Clear or relocate the content only after confirming what it is used for.

When the obstruction is safe to remove, select the cell and press Delete on Windows. This clears its contents while leaving the cell itself in place. You can also use Home > Clear > Clear Contents. On a Mac, the Delete key may be labeled Forward Delete; use the key that clears the selected cell’s contents in your Excel version. Avoid choosing Delete Cells unless you specifically intend to shift surrounding cells, because shifting data can alter a worksheet’s layout.

If the destination range must hold other information, do not clear it to make the formula fit. Put the formula in a genuinely open area, or revise the layout so the generated results and manually maintained data have separate spaces. This is especially important for reports that refresh or expand.

Common cause: merged cells or an Excel table

A merged cell anywhere in the required output area can prevent Excel from spilling an array. If the warning identifies a merged cell, select it and use Home > Merge & Center > Unmerge Cells, then make sure the resulting cells are available. If the merge is needed for presentation, place the formula somewhere else rather than changing a layout that other users depend on.

Spilled array formulas are not supported inside Excel tables. A formula in a table column is normally treated as a calculated-column formula, which fills down the table, while a dynamic-array formula may need to spill across or beyond multiple cells. Put the array formula outside the table in an open range, or use a table design that does not require a spilled result. To turn a table into a normal range, select a cell in it and use Table Design > Convert to Range; this changes the table’s behavior, so do it only if you no longer need table features such as automatic expansion and structured references.

When the formula returns too many or changing results

A formula can need more room than the sheet provides. Excel worksheets have 1,048,576 rows and 16,384 columns, ending at column XFD. If a result would extend past a worksheet edge, Excel cannot display it. Move the formula to a location with sufficient room, or limit the source data or result to the rows and columns you actually need.

Some spill messages refer to an unknown spill size or insufficient memory. These can occur when Excel cannot determine the output dimensions or when a formula attempts to generate an extremely large array. Review the formula for whole-column calculations or unnecessarily broad input ranges, and narrow those ranges to the actual data. If the output size depends on changing or volatile calculations, consider using a predictable range or separating the size calculation from the array-producing formula.

Do not assume that every large-looking formula needs more computer memory. First check the message and formula dimensions. A modest result blocked by one occupied cell is a different problem from an array that would require millions of results. The appropriate repair depends on which condition Excel reports.

A reliable way to fix and prevent repeat errors

Once you know what is blocking the array, choose a fix that preserves the worksheet’s intended data and layout. A useful repair sequence is:

Use the warning message and outlined range to locate the cause.
If an unwanted value blocks the range, clear or move that value. If it is needed, relocate the formula or the data instead.
If the problem is a merged cell, unmerge it only when appropriate, or choose another output location.
If the formula sits in a table, place it outside the table or redesign the calculation for the table’s calculated-column behavior.
Check whether the formula’s expected results fit within the available worksheet area and whether its source range is unnecessarily large.

For recurring reports, leave a clear output area for dynamic-array formulas and avoid typing notes or totals inside it. Put labels above or beside the expected results, not in cells where the array may expand. If the source data grows, leave enough room for likely growth or position the output on a separate sheet. These practices reduce accidental conflicts when someone pastes data or refreshes a report.

Be careful with repeated clearing as a “fix.” If an import or refresh keeps restoring the same blocking content, address the source or change the report layout. Otherwise, the error will return the next time that process runs, and clearing the cell may remove information the workbook needs.

What a spill error is—and is not

#SPILL! is distinct from errors such as #VALUE! or #REF!. Those usually point to an issue with a value, calculation, or reference; #SPILL! specifically indicates that Excel cannot display an array result in its required range. Removing a blocker can therefore fix #SPILL! without changing the formula, but it will not repair an unrelated error in the formula itself.

It is also not a warning that the formula has permanently filled every cell in the range. The spill area is controlled by the anchor formula and may resize as inputs change. You generally edit the anchor formula, not the individual result cells. If you need a fixed list, you can copy the results and use Paste Special > Values in another location, but those pasted values will no longer update automatically when the original source changes.

Frequently Asked Questions

How do I find what is blocking a spill in Excel?
Select the #SPILL! cell, inspect its dashed outline, and select the warning icon. If Excel offers Select Obstructing Cells, choose it to jump to the blocker. Check for formulas returning an empty string or a single space as well as visible values.

Can formatting alone cause a #SPILL! error?
Ordinary formatting such as color, borders, or number formats does not by itself make a cell occupied. Content does: that includes text, values, and formulas, even when a formula’s displayed result appears blank.

Why does my formula show #SPILL! inside a table?
Excel tables do not support spilled array formulas within their body. Move the formula to an open range outside the table, or choose a calculation method that returns one value per table row.

Does #SPILL! mean my formula is wrong?
Not necessarily. A valid dynamic-array formula can show #SPILL! because its destination cells are occupied, merged, inside a table, or beyond the worksheet boundary. Read Excel’s specific warning before changing the formula.

Why did my spill error appear after it worked before?
The spill range may have expanded, or new content may have been pasted into it. A data refresh, formula edit, or change to the source data can also alter the number of results. Recheck the outlined range and the message to find what changed.

Can I type into one of the spilled result cells?
No. The output cells belong to the anchor formula’s spill range, so Excel controls their displayed results. Edit the source data or the anchor formula; to keep a separate, non-updating copy, paste the results as values elsewhere.

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.