Excel's dynamic arrays are formulas that return several values and write them automatically into neighboring cells: this is spilling. The result range is referenced by the # operator after the address of the originating cell. If a neighboring cell is occupied, the formula returns a spill error (#SPILL!).
Example
=B2:B10*2 writes nine results from the cell where it is entered; =D2# designates the entire result range.