Filtering by an excluded field’s value
This method enables you to hide the records containing a particular value in the chosen field (column).
To filter records excluding a particular field’s value:
Right-click the cell that contains the value you want to hide and choose Filter > Filter Excluding Selected Field from the pop-up menu.
Only the records which don’t contain the chosen value in the chosen field are displayed.