Tables are best suited to holding rows and columns of independent data. Spilled array formulas are not supported in Excel tables themselves, so you should place them in the grid outside of the Table. This is because structured references automatically adjust as rows are added or removed from the table. If you are writing a dynamic array formula to act on a list of data, it can be useful to place it in an Excel table, then use structured references to refer to the data. When you press Enter to confirm your formula, Excel will dynamically size the output range for you, and place the results into each cell within that range. But you only need to enter the formula in the top left cell, or F2 in this case, and it will automatically spill down to cell F11. For example, =SORT(D2:D11,1,-1), which sorts an array in descending order, would return a corresponding array that's 10 rows tall.
Spill means that a formula has resulted in multiple values, and those values have been placed in the neighboring cells. The spilling behavior described in this topic does not apply to legacy array formulas. Note: Older array formulas, known as legacy array formulas, always return a fixed-size result - they always spill into the same number of cells.
