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.