Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

For Excel 365, formulas that return a set of values (or an array) are able to spill. Therefore, you can have your formulas spill when using simple calculations, as we did here, and also when using ...