Excel #SPILL! Range Isn’t Blank: Causes and Fixes

In Excel, “Spill range isn’t blank” means a dynamic-array formula needs to return results into cells that are not empty. Find the cell or cells blocking the output, move or clear their contents, and Excel can spill the results; check the contents before clearing anything you need.

What the “Spill range isn’t blank” error means

Microsoft 365 Excel can return several results from one formula. Instead of entering a separate formula in each output cell, you enter one formula and Excel fills the neighboring cells with its results. That output area is called the spill range. If even one cell Excel needs for the output already contains something, the formula cannot place its results and displays #SPILL!.

The message is about the destination, not necessarily a problem with the formula’s calculation. For example, a formula can calculate five values correctly but fail to show them because a note, a number, or another formula occupies one of the five destination cells. Excel leaves the existing contents in place rather than overwriting them.

When you select the formula cell, Excel may outline the intended spill area with a dashed border. That outline helps you see which cells need to be available. The formula cell itself is the top-left cell of the output; the other cells in the outlined area are where the remaining results would appear.

How dynamic-array spilling works

Some Excel formulas naturally return arrays: groups of values rather than just one value. Functions such as SORT, FILTER, UNIQUE, and SEQUENCE can produce these results in Microsoft 365. A formula entered in one cell can therefore populate multiple rows or columns. The results are linked to the formula cell, so you generally edit the formula in that top-left cell rather than typing into an individual result cell.

For example, with a formula entered in D2, =SEQUENCE(5) returns the numbers 1 through 5 in D2:D6, provided those destination cells are clear. If D4 already contains “Pending,” Excel cannot place the third result there and displays #SPILL! in D2. After you move or remove the blocking content, the sequence can appear.

Spill ranges can change size when the source data or formula changes. A FILTER formula, for instance, might return two rows today and six tomorrow as the source data changes. Keeping the area below and beside a dynamic-array formula available is therefore useful when you expect its result to grow.

How to find the cell blocking the spill

Start by selecting the cell that displays #SPILL!. Look for the dashed outline around the intended output area, then inspect the cells inside it. In Microsoft 365 Excel for Windows, you can also select the error cell and use the error-checking icon next to it, then choose Select Obstructing Cells when that option is offered. Excel selects cells it identifies as blockers.

If the error icon is not visible, inspect the outlined range directly. A cell can look empty while still containing something, so check the formula bar when you select it. Common invisible or easy-to-miss blockers include:

A space, an apostrophe, or another text character that is difficult to see.
A formula that returns an empty string, such as a formula whose displayed result looks blank.
A value or formula in a hidden row or column. Hiding a cell does not make it available for a spill.
Content far enough down or across the sheet to fall inside a larger-than-expected output range.

Formatting by itself—such as a fill color, border, or number format—does not normally make a cell nonblank for this error. Focus on cell contents rather than removing formatting. Also check the formula’s expected dimensions: the spill area may be larger than you assumed because the source range or filtering conditions include more records.

Fix the error without losing useful data

Do not immediately clear the whole outlined area if it might contain work. First identify which cells contain content and decide whether it belongs somewhere else. A safe repair is to move the blocking value or formula to an unused location, or adjust the dynamic-array formula so its output goes to a clear area. Once no blocking contents remain in the required destination, Excel recalculates the spill automatically.

Select the #SPILL! formula cell and note the outlined destination range.
Inspect the obstructing cells, including hidden rows and columns, and check the formula bar for contents that are not visible in the grid.
Copy or move any useful content to another location before removing it from the spill area.
To remove unwanted contents while retaining cell formatting, select only the obstructing cells and choose Home > Clear > Clear Contents.
Confirm that the formula now returns its results in the intended cells.

Deleting a cell or shifting cells can change the layout around the formula, so clearing only the unwanted contents is often the least disruptive option. If you are unsure what a cell contains, copy it elsewhere or save a copy of the workbook before making broad changes. On Excel for Mac and Excel for the web, the ribbon layout can differ slightly, but look for the Clear Contents command; the steps above describe Microsoft 365 Excel for Windows.

Cases that look similar but need a different fix

Not every #SPILL! message means an ordinary value is blocking the output. Excel gives other spill-related explanations, and the wording beside the error can point to the right remedy. For example, merged cells in the intended output area can prevent a spill even if they appear empty. Unmerge the relevant cells or place the formula where its output does not overlap them.

Dynamic-array formulas also cannot spill from inside an Excel Table in the same way they do in a normal worksheet range. If the formula is in a table column and Excel reports a table-related spill problem, place the formula outside the table or convert the table to a regular range if that suits the workbook. A table can still be a useful source for a dynamic-array formula placed elsewhere.

Other messages can identify an output that extends past the worksheet edge or a spill range that is not supported in the current context. These are not fixed by clearing a random cell. Read the full error explanation shown by Excel and check the formula location and expected output dimensions. The specific “Spill range isn’t blank” message, however, directs you to look for content in the destination cells.

Why a cell that looks blank can still block results

A blank-looking cell is not necessarily empty. A formula such as an IF calculation can return an empty string, making the cell appear blank while leaving a formula in it. A typed space has a similar visual effect. Excel still treats those cells as occupied for spill purposes, so a dynamic-array formula cannot use them as output cells.

To check, select the suspected cell and read the formula bar. If there is a formula or text, decide whether it should be moved, deleted, or incorporated into a different layout. If a formula is intentionally returning an empty string, consider moving that formula outside the expected spill area or redesigning the output so the two formulas do not need the same cells.

Do not rely on making the blocker white, changing its number format, or hiding its row. Those changes affect how the sheet looks, not whether the cell contains a value or formula. Clear Contents removes cell contents while leaving formatting behind, which is often a better targeted fix than clearing all formatting.

Preventing recurring spill errors

Dynamic-array formulas are easiest to maintain when their output space is planned rather than shared with hand-entered notes or other formulas. If the output size can vary, leave a generous clear area around the formula and keep explanatory notes in a separate column or above the results. Where space is limited, move the formula to a dedicated worksheet or a section that is not used for manual data entry.

Keep a clear area below and to the right of formulas that may return multiple rows or columns.
Avoid typing notes, totals, or helper formulas inside an expected spill range.
When a formula uses a growing source list, allow for future results rather than only the current output size.
Use a normal worksheet range for the spilled output instead of placing the dynamic-array formula inside a table.
When a spill error appears, check the exact error explanation before changing the formula.

One helpful distinction is that the formula’s source data and its destination are different things. A source list can contain many entries and still be valid; the error occurs when the results cannot be placed in the destination. Moving the formula to a free area may resolve the problem without changing the source data at all.

Frequently Asked Questions

Does “Spill range isn’t blank” mean my formula is wrong?
Not usually. It generally means the formula’s intended output cells are occupied. Check the spill outline and the contents of the destination cells before rewriting the formula.

Why does Excel show this error when the cells look empty?
A cell may contain a space, hidden text, or a formula returning an empty string. Select it and inspect the formula bar; visual appearance alone does not confirm that a cell is empty.

Can I fix the error by deleting the spill range?
You can remove unwanted contents from obstructing cells, but first check whether they contain information you need. Clear only the blockers, or move their contents, rather than deleting a larger range indiscriminately.

Will formatting block a spill in Excel?
Formatting alone normally does not cause the “Spill range isn’t blank” error. Values, text, and formulas in the destination are the main things to check. Merged cells can cause a separate spill problem.

Why does my dynamic-array formula fail inside an Excel Table?
Dynamic-array formulas cannot spill within a table’s body as they can in an ordinary worksheet range. Put the formula outside the table, where its output can occupy a clear range, or reconsider the table layout.

Will hiding a row or column clear the obstruction?
No. Hidden cells still contain their contents and can block a spill. Unhide the relevant rows or columns if needed, then move or clear the content in the destination cells.

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.