How to Fix the #SPILL! Error in Excel

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for fixing #SPILL! errors in Excel, with dynamic-array troubleshooting visuals.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for fixing #SPILL! errors in Excel, with dynamic-array troubleshooting visuals.

A #SPILL! error in Excel means a dynamic-array formula wants to return several values but cannot place them, usually because something already sits in the cells it needs. Clear the blocking cells, or move the formula out of a Table or merged area, and the results appear. The blocker is not always obvious, so this tutorial shows where to look.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Once you understand the common causes, spill errors become much easier to diagnose and prevent.

What does a #SPILL! error mean?

A #SPILL! error means Excel cannot place a formula's results, usually because the output range is blocked. Other causes are a context that does not allow spilling, or source logic that produces an array shape Excel cannot lay out cleanly.

  • A dynamic-array formula suddenly stops returning results.
  • A workbook mixes new array functions with older layout habits.
  • You are building reports that depend on spill ranges behaving consistently.

What is the most common cause of a #SPILL! error?

The most common cause of a #SPILL! error is that cells in the intended spill area are not empty. The formula is fine, but the output has nowhere to land.

What else causes a #SPILL! error?

Tables, merged cells, legacy layout habits and formulas that create awkward result shapes can also cause a #SPILL! error. The error is often about workbook design as much as formula logic.

If you want to learn dynamic arrays with an instructor, try The Complete Excel Course with AI Integration on Coding Liquids.

How do I stop a #SPILL! error coming back?

To stop a #SPILL! error coming back, give spill formulas room, avoid placing stray values next to them, and design report tabs so dynamic outputs have a clear landing zone.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Worked example: filtered report section

A FILTER formula is meant to spill customer rows into a report area, but an old note still sits below the first output cell. Clearing that blocker removes the error immediately.

Common mistakes

  • Debugging the formula first when the spill range itself is blocked.
  • Mixing decorative layout habits with dynamic-array outputs.
  • Forgetting that spill results may grow when source data grows.

When to use something else

If the issue is more about slicing arrays than fixing errors, TAKE, DROP, CHOOSECOLS, and CHOOSEROWS are the better next tools.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Frequently asked questions

What does a #SPILL! error mean?

It means a dynamic-array formula cannot place its result. The spill range may be blocked, the formula may sit in a context that cannot spill, or it may produce a shape Excel cannot lay out. Select the cell with the error to see the intended spill range, then check what is inside it.

What is the most common cause?

Something is already in the spill area. The formula is fine; the output has nowhere to land. Select the error cell, open the error menu and choose 'Select obstructing cells', then clear or move whatever it highlights, and the formula should spill again.

What else triggers #SPILL!?

Spilling inside a Table triggers it, because Tables do not allow spilling. Merged cells in the way can too, as can a formula that returns an unexpectedly large or odd-shaped array. It is often a workbook-design issue as much as a formula one, so check the layout around the formula as well as the formula itself.

How do I find what is blocking it?

Use the error menu's 'Select obstructing cells', which highlights what is in the way. You can also scan along the intended spill range for stray values, cells that look empty but hold something such as a space, or merged ranges. Clear or move whatever you find, then check that the formula spills.

How do I stop #SPILL! happening repeatedly?

Give spill formulas open space and do not park stray values beside them. Unmerge cells in report areas, and design each tab with a clear landing zone for dynamic outputs. Spill results may grow when the source data grows, so leave room below and beside the formula, not just enough for today's result.

Can I use a spill formula inside a Table?

No. Excel Tables do not support spilling, so a dynamic-array formula inside one returns #SPILL!. Move the formula outside the Table, or convert the Table to a range if the spill is what you need there. Either way, keep the cells the results spill into empty.

Related guides on this site

If you want to keep going without opening dead ends, these are the most useful next reads from this site.