This may be because the filter range was inadvertently defined incorrectly, because there is a hidden blank row before the last row or because the problematic row was added after the filter range was defined. Note that the row numbers have turned blue. Identifying Dups In Excel Excel I Need A Job Learning This is confirmed by the fact that the application of the filter does not turn the row number indicator blue. Excel filter not working on new rows . So in this case, after a certain row, the filter does not include them. Recreating the filter initially didn't work, but i deleted several rows immediately following the last row of my data, removed the filter, and created a new filter, and that fixed the problem. This range does not update upon the adding of rows or columns. I'm guessing one of those rows kept getting put in the filter even though it was blank and that was causing the problem to begin with. See if any of the 8/1/2017 have a single quote in front of ...