Spill range in Excel

A spill range is the block of cells that a single dynamic array formula fills with its results, and it is the range Excel reserves so the output has somewhere to land.

A spill range is written with the hash operator, so A1# refers to everything the formula in A1 returned.

A spill error appears when something already occupies the space the results need, which often happens after a model is pasted into a workbook that already had content there.

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.