Why are filters in an excel sheet showing unmatched rows?
Issue caused by blank (empty) cells at the column you are filtering. The actual problem occurred upon filter creation, while you made filter when you had first cell selected instead of whole column.
How to fix it:
- Click at the first cell and press Filter again to delete current filter;
- Then click at the first column and press Filter to create a new one.
Now it will works like a charm. :)