Dynamic array behavior

Dynamic arrays differ from legacy function arrays in that its content is determined only by the formula in the top left cell of the dynamic array, called the SpillParent of the array. The rest of the array which holds the function output is called the SpillingToRange. In the figure below, the cell outlined in green is the SpillParent, and the entire region outlined in blue is the SpillingToRange. If you select another cell within the SpillingToRange, notice that you are unable to modify the formula in the formula bar.

If the dynamic array cannot fit within a region of the spreadsheet, only the top left SpillParent cell shows with the message #Spill! (as shown in the screenshot below).