How to Fix Spill Error in Excel

To fix a #SPILL! error in Excel, select the cell showing the error, check the outlined spill range, and clear or move anything blocking the intended results. Also check for merged cells, a formula entered inside an Excel table, or an output range that is too large. A spill error means Excel cannot place a dynamic array formula’s results in the cells it needs.

What You’ll Need

Excel for Microsoft 365 on Windows, or another recent Excel version that supports dynamic array formulas.
Access to the workbook and permission to change the cells around the error.
A saved copy of the workbook if the data is important or you are unsure what is safe to remove.

You do not need an add-in or a special repair tool. If someone sent you the workbook, ask whether the formula is supposed to return multiple results; some spill formulas are designed to do so.

Step-by-Step

Select the cell with #SPILL!. This is usually the formula’s starting cell, also called the anchor cell. Read the formula bar to confirm that the cell contains a formula, and look for a dashed outline around the area where Excel expects to put the results. That outline shows the intended spill range. If you cannot see it, click the error cell again and check the error message or warning icon beside it.
Read Excel’s specific error message. Select the warning icon next to the cell, if it appears. Excel may describe the problem, such as a spill range that is not blank, a merged cell, or a formula inside a table. On Windows, the error menu may also offer Select Obstructing Cells. Choose it when available to jump to a cell preventing the results from spilling. The wording and menu options can vary slightly by Excel version.
Check every cell in the outlined range for contents. A cell can look empty and still block a spill if it contains a space, an apostrophe, a formula returning an empty string, or other hidden content. Inspect the formula bar when you select suspicious cells. If the content is not needed, select the blocking cells and choose Home > Clear > Clear Contents. This removes cell contents without removing formatting. If the contents are important, move them elsewhere instead of clearing them.
Check for merged cells. A dynamic array cannot spill into a range containing merged cells. Look across the outlined area for merged headings or other merged cells. If a merge is the obstacle, select the merged cell and use Home > Merge & Center to turn merging off, or move the formula so its output range no longer overlaps the merged area. Unmerging can change how a heading looks, so check the layout afterward.
Check whether the formula is inside an Excel table. Dynamic array formulas that return multiple results cannot spill from a formula cell inside a structured Excel table. If the anchor cell is in a table, place the formula in a normal worksheet cell outside the table, leaving enough empty cells for the results. Alternatively, use a suitable table-based approach that returns one result per row. Do not convert a table to a range unless you are comfortable losing table features such as automatic expansion and structured references.
Make sure the expected results fit on the worksheet. Excel cannot spill beyond the last row or column. If a formula starts near the bottom or right edge, move it to a location with more room or reduce the amount of data it processes. For example, a result expected to extend downward needs enough available rows below its anchor cell. Check that the output area is clear before moving the formula.
Review the formula’s inputs and expected output size. A formula may return more rows or columns than you expect because its source range includes extra records, blank-looking rows, or a condition that matches many items. Confirm the source range and criteria, and adjust them if the output should be smaller. If the formula uses a function whose result size can change during calculation, recalculate after checking its inputs. Do not delete source data simply to make the error disappear.
Recalculate and confirm the results. After clearing or moving the obstruction, press Enter in the formula cell if you edited its formula, or use Formulas > Calculate Now to recalculate the workbook. Confirm that the results fill the intended range and that no important values were overwritten or moved. If #SPILL! remains, note the exact message and continue with Troubleshooting below.

On Mac, the same checks apply, though some ribbon labels and keyboard behavior may differ. Use the Home tab’s Clear controls to remove contents; the Delete key may behave differently depending on the keyboard. In Excel for the web, use the Home tab to clear contents and inspect the error message, but some desktop error-menu options may not be available. Open the workbook in desktop Excel if you need those options.

Common Mistakes

Deleting the formula instead of the blocker. The formula cell is the source of the results, not usually the obstruction. Clear or move cells inside the outlined destination range, and keep the anchor formula unless it is genuinely incorrect.
Assuming a blank-looking cell is empty. Spaces, hidden characters, and formulas that display nothing still count as contents. Select the cell and inspect the formula bar before deciding what to remove.
Trying to edit one result cell in a spilled range. The individual results belong to the anchor formula. To change the output, edit the formula in the anchor cell or change its source data. Excel may show a message that part of an array cannot be changed.
Clearing a whole column or row without checking it. That can erase unrelated values. Use the spill outline to identify the intended destination and clear only the cells that truly block it.
Moving a formula into another table cell. If the new location is still inside an Excel table, the same table restriction can cause the error again. Place it outside the table and leave room for its results.

Tips

Keep dynamic array formulas in a clearly marked area with enough open space for their output. This reduces collisions with notes, totals, and future data entry.
When a result is meant to grow over time, avoid placing fixed values directly below or beside the formula. Put notes in another area or on a separate worksheet.
Use the spill outline as a diagnostic tool, not as a guarantee that every cell in it is visibly occupied. A single hidden space or merged cell can prevent the entire result from appearing.
Before changing a shared workbook, check whether other people rely on the data in the blocked cells. Moving the obstruction may be safer than clearing it.
If the workbook is large, make a copy before altering formulas or source ranges. This gives you a way to restore the original layout if the fix changes other calculations.

Troubleshooting

The error says the spill range is not blank, but the cells look empty. Select the cells inside the outlined range one at a time, especially the first cell Excel identifies as obstructing. Check the formula bar for a space, apostrophe, or formula. Use Home > Clear > Clear Contents only after confirming the content is disposable. If you cannot identify the cell, temporarily move the formula to a clear area of the worksheet. If it works there, the original destination contains an obstruction or layout conflict.

The error mentions a merged cell. Unmerge the specific cell that overlaps the output area, or reposition the formula. If the merged cell is a heading, consider centering the heading across selected cells without merging them, so the array can use the cells it needs. Check that unmerging does not alter the appearance or placement of important labels.

The formula is in a table, or Excel says the spill range is unknown. Move a multi-result formula outside the table. If the message refers to an unknown spill range, the formula may produce an output size that changes during calculation. Review references to volatile calculations or changing inputs, then try recalculating. If the message says the range is too large, narrow the source data or revise the formula’s criteria rather than repeatedly retrying it.

The spill works in a blank area but not where you need it. Compare the two locations for hidden contents, merged cells, table boundaries, and available rows or columns. The difference usually identifies the obstacle. If the formula must stay in its current location, reorganize the surrounding worksheet so its expected output area is free.

The error persists after clearing the apparent blocker. Confirm that you cleared the entire outlined range, not just the first obstructing cell, and then recalculate. Check whether a new obstruction appears because the result is larger than expected. If the formula was recently edited, undo the edit if appropriate or restore the saved copy, then inspect the formula and source data before trying again.

Frequently Asked Questions

What does #SPILL! mean in Excel?
It means a formula is trying to return multiple results, but Excel cannot place all of them in the required worksheet cells. The formula may be valid; the destination or output size is the issue.

Can I fix #SPILL! by deleting the formula?
You can remove it, but that removes the calculation rather than fixing the cause. First inspect the outlined spill range and resolve the specific obstruction. Delete the formula only if you no longer need its results.

Why does a cell with a formula that looks blank block a spill?
A formula can display an empty-looking result while still occupying the cell. Excel treats that cell as part of the worksheet content, so a spill cannot use it. Move or remove the formula if it is safe to do so.

Can I type over one value in a spilled result?
No. The results are controlled by the formula in the anchor cell, so editing one result within the spill range is not supported. Change the anchor formula or its source data instead.

Does #SPILL! mean my workbook is damaged?
Usually not. It is generally a calculation or layout conflict, such as occupied cells, merged cells, a table restriction, or insufficient worksheet space. Read the error detail and correct that specific cause.

Will these steps work in older Excel versions?
They apply to Excel versions with dynamic array formulas, including Microsoft 365. Older versions may not support the formula that produced the error, so check the function’s availability and open the workbook in a version that supports it.

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.