A quick way to filter a table is with the Filter by Selection feature. This allows you to streamline the results and make sure you are seeing the exact information that you’re searching for.
You can also apply a selection filter by right-clicking the field value you want to filter by and selecting one of the options at the end of the contextual menu.
Filter by Selection Menu Commands
Equals [selected field value]
Displays only records with the selected value.
Example: If John is selected, only records with John in this column are displayed.
Does Not Equal [selected field value]
Displays all records that don't contain the selected value. Example: If John is selected, records with John in this column are not displayed, but Johnson is.
Contains [selected field value]
Displays all records that contain the selected value in any form. Example: If John is selected, John and Johnson are displayed.
Does Not Contain [selected field value]
Displays records that don’t contain the selected value in any form. Example: If John is selected, neither John nor Johnson is displayed.