Excel Spill Error: Why It Happens and How to Fix It

Errors & fixes · Updated November 3, 2026

To fix Excel’s #SPILL! error, select the cell showing the error, identify the intended spill range, and remove whatever is blocking that range—or adjust the formula so its results fit. In Microsoft 365 for Windows, a dynamic array formula starts in one cell and returns results into neighboring cells; Excel shows #SPILL! when it cannot place those results.

The error usually does not mean the formula itself is invalid. It means Excel cannot display the formula’s full output where it is currently located. Clearing an obstruction is often enough, but the right fix depends on whether the cause is occupied cells, a table, merged cells, or an output that is too large or unpredictable.

What a spill error means

Older Excel formulas generally returned a value in the cell where they were entered. Dynamic array formulas can return several values at once. Excel places the formula in an anchor cell, then fills adjacent cells with the results. That output area is called the spill range. The anchor cell contains the formula; the other cells in the range display its results.

Functions such as FILTER, SORT, UNIQUE, and SEQUENCE can produce arrays that spill in Microsoft 365. For example, a formula that filters a list might return a different number of rows as the source data changes. Excel needs enough clear worksheet space for the result each time it recalculates. If even one required cell is unavailable, the formula can show #SPILL!.

This is different from an error such as #VALUE!, which points to a problem with a value or argument, or #NAME?, which can indicate that Excel does not recognize text in a formula. With #SPILL!, start by examining the output area, not by rewriting a formula that may already be correct.

Find the blocked spill range

Click the cell showing #SPILL!. Excel often outlines the area where the formula wants to return results with a dashed border. That outline is useful because the obstruction may be several rows or columns away from the formula cell. The error indicator or warning menu may also offer an option to select the obstructing cells.

Inspect the outlined area for values, formulas, or other obstacles. A cell can look empty but still contain a space, an apostrophe, or a formula that returns an empty string. Those contents can block a spill. Ordinary formatting, such as a fill color or border, does not by itself make a cell nonblank; clearing formatting is generally not the first step.

If the cells are safe to clear, select only the obstructing contents and use Home > Clear > Clear Contents. This removes cell contents while leaving formatting in place. Check carefully before clearing: an obstruction could be useful data, so move it elsewhere or choose a different formula location if it must be preserved. Once the range is clear, Excel should recalculate and display the results.

For example, if the anchor formula is in D2 and the dashed range extends from D2 to D8, a value in D6 can stop the entire output. Removing that one value may allow all seven results to appear. Do not delete rows or columns unless that is genuinely what you intend; clearing the conflicting cell is usually more precise.

Fix common causes of #SPILL!

Excel’s error details can help identify the particular cause. These are the common situations and the practical response for each:

  • Spill range is not blank: Clear or relocate content inside the outlined area. Check for formulas returning blank text and for cells that appear empty but contain spaces.
  • Spill range contains merged cells: Unmerge cells within the output area, or move the formula to a location where its results will not intersect merged cells. Merged cells prevent Excel from laying out the array normally.
  • Spill range is in a table: Dynamic array results cannot spill from a formula entered within an Excel Table. Place the formula outside the table, or use a different table-friendly approach, such as a calculated-column formula that returns one result per row.
  • Spill range extends beyond the worksheet edge: Move the formula or limit the output so it stays within the worksheet’s available rows and columns. A result cannot spill past the final worksheet row or column.
  • Spill range is too large or Excel reports insufficient resources: Reduce the input range or output size. Avoid asking a formula to process an unnecessarily broad area when a smaller, relevant range will do.
  • Excel cannot determine the spill size: Review formulas whose output dimensions depend on volatile calculations. Make the expected output size more stable where possible.

A common misconception is that every cell in the spill range must be formatted or prepared in advance. It does not. Excel can spill into cells with existing formatting, provided those cells do not contain blocking content and are not otherwise incompatible, such as merged cells.

Tables, merged cells, and formula placement

Excel Tables are useful for sorting, filtering, and expanding structured data, but they handle formulas differently from a regular worksheet range. A formula entered in a table column is usually treated as a calculated-column formula, which fills down the table. A dynamic array formula that needs to spill multiple results into neighboring cells cannot spill from within the table body.

The simplest solution is often to put the array formula in an ordinary worksheet cell outside the table, leaving enough blank space for its results. You can still refer to table data from that formula. If you are considering converting the table to a normal range, use Table Design > Convert to Range only after weighing the change: the data remains, but table-specific behavior such as automatic expansion and structured table features is lost.

Merged cells create a separate issue. Even if the anchor cell itself is not merged, any merged cell intersecting the spill range can stop the output. Unmerge the relevant area or reposition the formula. If the worksheet uses merged headings for appearance, keep those headings outside the expected output area rather than unmerging the whole sheet without checking its layout.

Check the formula and its expected output

Before changing a formula, estimate how many rows and columns it should return. A single-column list that may contain hundreds of matches needs clear cells below the anchor. A two-dimensional result needs room in both directions. If the source data grows, leave a suitable buffer or place the result on a separate sheet where it is less likely to collide with other content.

Here is a simple example. With the formula entered in A1, it returns the numbers 1 through 5 and needs cells A1:A5 available:

=SEQUENCE(5)

The result is 1, 2, 3, 4, and 5 in five vertical cells. If A4 already contains a note, Excel cannot show the complete sequence and may report #SPILL!. Move the note or place the formula in a clear location. SEQUENCE is available in Microsoft 365 and Excel 2021 or later.

For a variable-length result, consider whether the source range is broader than necessary and whether the formula can return more rows than expected. A filter formula might return no matches, a few matches, or many matches depending on the data. If its intended output overlaps a report, notes, or another formula, relocate the output or redesign the layout instead of repeatedly clearing cells.

When the error returns after you fix it

A spill range can change when the source data changes or when Excel recalculates. Clearing a blocking value may solve the current error, but a later addition elsewhere in the workbook could make the formula return more rows and collide with content again. Keep dynamic results in an area reserved for them, and avoid placing permanent notes directly below or beside a formula that can expand.

Also check whether the formula’s inputs are changing. For instance, a filter based on a status column may return additional rows as records are marked with that status. If the formula is in a shared or regularly updated workbook, agree on a clear output area or use a dedicated results sheet. This is more reliable than moving obstructions whenever they appear.

If the error remains after clearing the apparent obstruction, inspect the entire outlined range, not only the first few cells. Look for merged cells, hidden rows or columns that still contain data, and other formulas. Recheck the exact error detail shown by Excel; a table limitation or oversized result will not be fixed by clearing an unrelated cell.

Excel for Mac and Excel for the web

The spill behavior is broadly similar in Microsoft 365 for Windows, Mac, and Excel for the web: array formulas need room to return their results. The precise position of error icons and the wording or availability of menu options can differ by platform and release. If a warning menu does not offer a way to select blockers, use the dashed outline and inspect the relevant cells manually.

On Mac, clear the contents of selected cells using the available Clear Contents command or the keyboard’s Delete key, depending on the keyboard and Excel release. Be mindful that keyboard behavior can differ between Mac keyboards. Excel for the web also lets you edit formulas and clear cell contents in the browser, though some desktop ribbon options may be arranged differently. The central troubleshooting step remains the same: identify the intended output range and remove or avoid the obstacle.

Frequently Asked Questions

Why does Excel say #SPILL! when the cells look blank?
A cell may contain a space, an invisible character, or a formula that returns an empty string. Check the outlined spill range and inspect or clear the contents of suspicious cells. Formatting alone usually does not block a spill.

Can I keep a note inside a spill range?
No. The note occupies a cell Excel needs for the array result. Move the note outside the expected spill area, move the formula, or change the formula so its output does not need that cell.

Why does #SPILL! happen inside an Excel Table?
Dynamic array results cannot spill from a formula entered within a table. Put the formula in a normal worksheet range outside the table, or use a table formula designed to return one result for each row.

Does #SPILL! mean my formula is wrong?
Not necessarily. It commonly means Excel cannot place the result in the required cells. Check the error detail and spill range first; if the area is clear and the formula still fails, then review the formula’s inputs and expected output.

How do I stop a spill error from coming back?
Reserve enough clear space for the formula’s likely output, especially if its result changes as data is added. Keep notes and other report content outside that area, or put the dynamic result on a dedicated worksheet.

A reliable troubleshooting order

Work from the output area outward: click the error, read its detail, and inspect the outlined spill range. Clear or move genuine obstructions, then check for merged cells and table placement. If the space is clear, consider whether the output is too large, reaches the worksheet edge, or has an unpredictable size. Finally, leave room for future growth so a formula that works today does not collide with new data tomorrow.

Related

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.