Remove Spill Error in Excel: Causes and Fixes

To remove a #SPILL! error in Excel, select the error cell, inspect the outlined spill range, and clear or move anything blocking the cells where the results need to appear. If the formula is not supposed to return multiple results, change the formula so it returns a single value instead; there is no universal button that fixes every spill error because the underlying cause can differ.

What the #SPILL! error means

Excel displays #SPILL! when a formula is trying to return multiple values into neighboring cells but cannot place all of them. Microsoft 365 and other newer Excel versions support dynamic arrays: a formula can calculate a list or grid of results, and Excel fills the required cells automatically. That output area is called the spill range.

For example, a sequence formula can return five numbers into five cells. If one of those cells already contains data, Excel cannot place the complete result and reports #SPILL! in the formula cell. The error does not necessarily mean the calculation itself is invalid. It often means the calculation is ready, but its destination is unavailable.

Select the cell showing the error. Excel may show a dashed outline around the intended spill range and an error indicator with more information. The outline helps locate the obstruction, including cells that are outside the visible portion of the sheet. Fixing the cause usually restores the results without changing the formula.

Quick steps to fix a blocked spill range

Select the cell with #SPILL! and read the error message shown beside it, if available.
Look for the dashed outline showing where the formula wants to put its results.
Check every cell inside that outline for existing values, formulas, merged cells, or other restrictions.
Move or clear the obstruction, or change the formula or its location if the output area should not be used.
Check that the full output range is now visible and that the formula cell no longer shows the error.

In Excel for Microsoft 365 on Windows, you can clear selected blocking cells by choosing Home > Clear > Clear Contents, or by selecting them and pressing Delete. Clearing contents preserves cell formatting. Avoid using Delete Cells unless you intend to shift neighboring cells, because shifting cells can alter the layout or references. On Mac, the ribbon command is also available under Home > Clear; the keyboard key for clearing contents may be labeled Delete or Backspace depending on the keyboard. Excel for the web has similar clearing options, though the ribbon layout can vary.

How dynamic arrays and spill ranges work

Older spreadsheet formulas generally returned one result to one cell. Dynamic-array formulas can return a group of results from a single formula cell. Excel calls the formula cell the anchor cell, and the surrounding cells filled by its results are the spill range. The results are linked to the anchor: you edit the formula in that first cell, not each displayed result separately.

With D2 as the formula cell and D2:D6 otherwise empty, enter =SEQUENCE(5). Excel returns 1, 2, 3, 4, and 5 down the five cells. If D4 contains a value, the formula cannot place the third result there and returns #SPILL! instead. Remove or move the value in D4 and the sequence can appear. SEQUENCE is available in Microsoft 365 and Excel 2021 or later.

Dynamic-array results can extend vertically, horizontally, or in both directions, depending on the formula. The size is not always obvious from looking at the formula, so use the outlined spill range rather than assuming only the cell directly beside the formula is involved. A spill range can also change size when its source data changes.

Common causes of #SPILL! and what to look for

Occupied cells: A value, space, or another formula in the intended range can block output. A cell may look empty but contain a formula that returns an empty string, or contain an invisible space.
Merged cells: A merged cell anywhere in the spill range can prevent Excel from filling the range. Unmerge the relevant cells or move the formula to an unmerged area.
Formula inside an Excel table: Dynamic-array formulas cannot spill from within a table body. Put the formula in a normal worksheet range outside the table, or restructure the calculation so each table row returns one value.
Output would run beyond the worksheet: A formula near the bottom or right edge of the sheet may need more rows or columns than remain available. Move it or limit the intended output.
Uncertain or excessive output: Some formulas cannot establish a usable spill size, or may request more results than Excel can place. Check the error detail and reduce or constrain the result where appropriate.

Formatting alone, such as a fill color or border, does not normally block a spill. A blank-looking cell is worth investigating, but you do not need to remove all formatting from the destination range as a first step. Use the error message and the outlined area to narrow down what Excel is reporting.

Fix the cause without damaging nearby data

Before clearing anything, inspect the cells in the outlined range. If a cell contains information you need, move that information to another location rather than deleting it. You can also move the formula to an empty area with enough room for the full result. This is often safer when the current location is part of a report or a carefully arranged worksheet.

If the blocker is a formula that displays nothing, select the cell and inspect the formula bar. Clearing that formula will make the cell available, but it also removes the calculation, so move or revise it if it serves another purpose. If the range contains merged cells, select the affected area and use Home > Merge & Center to turn off merging; the precise menu label can depend on the ribbon layout. Check the resulting cell values, since unmerging does not always preserve the appearance or layout you intended.

For a formula inside a table, place the dynamic-array formula in a worksheet cell outside the table and refer to the table data as needed. Do not convert a table to a regular range just to clear the error unless you are comfortable giving up table features such as automatic expansion and structured references. If a formula is intended to calculate one result per table row, a conventional row-by-row formula may be a better fit.

When to change the formula instead

Sometimes the spill behavior is correct, but the formula is in the wrong place. In other cases, the formula returns more results than the worksheet design calls for. Decide whether you need the whole list or just one value before changing it. Removing the spill by forcing a single result can hide information that the original formula was meant to show.

In some formulas, Excel’s implicit-intersection operator, @, can request a single intersecting value instead of an array of results. Whether that produces the desired answer depends on the formula and the data. Another option is to use a function that selects one item from a result, but the correct choice depends on whether the result is vertical, horizontal, or two-dimensional. Check the returned value against the intended calculation rather than treating the disappearance of the error as proof the formula is right.

If the output is simply too large, revise the formula’s criteria or source range so it returns only the records needed. For instance, a filter intended to show one department should not include the entire data set by mistake. A smaller, purposeful result range can make a report easier to read and reduce the chance of future obstructions.

Prevent spill errors in shared workbooks

Leave clear space around formulas designed to spill, especially in dashboards and templates where users may add notes or paste new data. Keep spill formulas outside Excel tables, and avoid merging cells in areas where results may expand. If the output size can change, reserve enough rows and columns for realistic growth rather than only the current number of results.

When building a shared workbook, explain which cells are formula outputs and which cells are safe for entry. Protecting formula cells can help prevent accidental edits, but worksheet protection should be configured carefully so users can still enter data where intended. Also consider whether a spill formula is appropriate for the workbook’s audience: recipients using older Excel versions may not have the same dynamic-array behavior, and compatibility can affect how formulas display or calculate.

Frequently Asked Questions

Can I remove #SPILL! without deleting the formula?
Yes. Usually you can keep the formula and clear or move the cells blocking its intended output. If the formula is in a table or the range includes merged cells, change its location or address that restriction instead.

Why does Excel show #SPILL! when the cells look empty?
A cell can look blank while containing a space or a formula that returns an empty string. Select the cells inside the outlined spill range and inspect the formula bar or clear contents only after confirming the data is not needed. Formatting by itself is generally not the obstruction.

Does #SPILL! mean my formula is wrong?
Not necessarily. The formula may be valid but unable to put all its results into the required cells. Read the error detail and inspect the proposed spill range before rewriting the calculation.

How do I fix #SPILL! in an Excel table?
Move the formula outside the table into a normal worksheet range if it needs to return multiple values. If the calculation should return one result for each table row, use a row-level formula design instead of a spilling formula inside the table.

Will clearing the spill range delete the formula?
Not if you clear only the blocking cells. The formula remains in its anchor cell. Make sure that cell is not included in your selection, and use Clear Contents rather than deleting cells if you want to preserve the worksheet layout.

Is #SPILL! available in older Excel versions?
#SPILL! is associated with dynamic-array behavior in newer Excel. Microsoft 365 and Excel 2021 or later support functions such as SEQUENCE; older versions may not calculate these formulas the same way. If a workbook is shared across versions, check compatibility with the recipients’ Excel editions.

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.