The list of available operators is based on the type of column selected for filtering. The following table provides a description for each operator. The operators are the same for filtering and conditional formatting.

 

Some tables provide a row of blank filter boxes above the column headers. Enter all or part of the text you want to filter by in the appropriate filter box. The table data is dynamically filtered to display items that contain matching values as you enter the filter criteria. You can combine filter criteria by typing values in more than one column.

Some tables support auto filtering (also referred to as cell filtering), which allows you to filter the list by the value of any cell. To use auto filtering, right-click a cell containing the value you want to filter, and select the Toggle Auto Filter option. (When enabled, the menu option is checked.) The table is refreshed to display only rows where the value matches the selected cell. For example, if you click a cell in the Feeder column with a value of "2413" and enable auto filter, the table will refresh to display only events for Feeder 2413. Click the option again to turn off cell filtering.

Filters are organized into main structures – Global, Personal, and Shared:

In addition, commonly accessed filters can be added to a Favorites structure, as a shortcut.

Each top-level structure also supports collapsible folders into which filters can be placed, to help organize work and other information.