#SPILL!Supported on: Microsoft Excel® & Google Sheets™

How to Fix the #SPILL! Error in Excel & Google Sheets

The #SPILL! error is unique to modern dynamic array formulas (such as FILTER, SORT, UNIQUE, or SEQUENCE) when the formula calculates an array of results but one or more cells in the output range already contain data.

Common Root Causes of #SPILL!

  • 1One or more cells inside the expected spill range contain text, numbers, or hidden formatting.
  • 2Merged cells intersect with the required spill area.
  • 3Formula results in an infinitely expanding dynamic array (e.g., referencing entire column A:A within a dynamic calculation).
  • 4The worksheet boundary is reached before the dynamic array finishes expanding.

Formula Syntax Comparison

Broken Formula
=FILTER(A2:C100, B2:B100="Completed") (blocked by note in cell C5)
Corrected Formula
=FILTER(A2:C100, B2:B100="Completed")

Manual Step-by-Step Fix

1

Step 1

Click the #SPILL! error cell to view the dashed boundary indicator showing the required spill range.

2

Step 2

Clear all blocking cell contents, values, or spaces inside the dashed box.

3

Step 3

Unmerge any merged cells located in the downstream output path.

Automate this Fix with SheetFactorys

Zero manual debugging required

SheetFactorys identifies intersecting cell contents and merged regions programmatically, unmerges obstructive blocks, and relocates blocking data or optimizes range boundaries seamlessly.

Available in Microsoft AppSource & Google Workspace
Install for Excel®Install for Sheets™