What is an Excel spilled range? First of all, a range in Excel is a collection of two or more cells. Those cells don’t necessarily have to be adjacent to each other.

Some Excel function spill. When you write the function in a cell, the results occupy more than one cell. The results “spill” into adjacent cells, to create a range. One example of this is the SORT function. The UNIQUE function also spills.

Learn with YouTube

Here is a video called When Should you Use the Hash Sign # in Excel Formulas by Leila Gharani?