Each filter is customized to match the contents of the column.
This list is dynamic.
If I change Purple to Yellow in a row, Yellow appears automatically in the filter menu.
I’ll undo that change.
To filter on a single value, click Select All, then check the value.
Notice a filtered column will display a different icon than an unfiltered column.
To clear a filter, use the Clear option in the menu.
This message will show how many records are currently visible.
Each filter also contains a search box that performs a “contains bang out” search.
Directly above the search box is a menu with commands linked to column contents.
Since colors are text values, the options here are for text.
In the Quantity column, this menu shows options for numbers, since quantity is numeric.
I’ll filter on records that have a quantity of greater than 17.
Each time you add a new filter, you’ll further restrict the number of records you see.
When I filter on the year 2016, we get an even smaller list of matching records.
Dates are automatically grouped by year and month.
In addition, dates will have a long list of options related to the current date.
When you toggle the filter controls this way, all filters are cleared and all rows are displayed.
This setting only toggles the visibility of filter controls.
