There are two ways to fix this cause of the #SPILL! error. First, select the entire spill range (or at least the cell or cells causing the blockage), and drag it to another area in the worksheet. On ...

Checking the error is the very first thing you need to do to fix this issue. Filters do not work properly when you have one or multiple errors in your spreadsheet. To ...