Filter Row lets users modify the presentation of data by assigning combinations of operators and values. The available operators depend on the data type of the column.
Operators
| Text | Numerical/Date |
| Contains | Equals |
| Does not contain | Does not equal |
| Starts with | Less than |
| Ends with | Greater than |
| Equals | Less than or equal to |
| Does not equal | Greater than or equal to |
| Between |
To enable Filter Row:
- Right-click on a Column Header.
- Select Filter Row.
Note: The filter row will populate below the column header.
- Click the Magnifying Glass Icon to select an Operator.
- Next to the operator, assign a value.
Note: For dates, users can select the Calendar Icon in the filter row.
The data is now filtered.
Related Articles: