Spill Range

Available in Excel 2021 and Excel 365.
Formulas that return more than one value but cannot populate all the adjacent cells will return #SPILL!


Spill range operator (# character)

To refer to the spill range, put a hash tag or pound symbol (#) after the address of the upper-left cell in the range.





© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext