Formula errors · Short guide

#SPILL in Excel! How to solve overflow error?

Braxorn · Last updated 2026-11-22 · English

Dynamic array formula wants to write results to more than one cell. Having content or merged cells in the target area can prevent overflow; Some formulas can also produce results that are large enough to exceed the page limit.

What can you do?

  1. Select the error cell and examine the overflow area and error description that Excel shows.
  2. Check the contents of the cells covering the area; Instead of deleting the necessary data, move the formula to a suitable empty area.
  3. Collapse all unnecessary column references and choose a location where the results can fit.

A small example

While a formula will write seven results in field E2:E8, if there is a note in cell E5, the output cannot be placed. Once you safely move the note, all results of the formula should appear.

What to watch for

Dynamic array results may be in an unsupported order within the Excel spreadsheet; It may be necessary to try the formula outside the table. Do not perform bulk cell cleaning without reading the error description.

Check the result

Compare the output row count and start/end cells with the expected data.

Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.

Microsoft source (English)

Microsoft source (English)

Review your own workbook

You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.

Review your file