Use column filters to conditionally display rows based on the data inside one or more columns.
To apply column filters, follow these steps:
Open the filter menu underneath a column header.
Select a filter type and enter a search value, or use the checkboxes to select from the available column values.
Column filter types
Here are some of the common column filter types:
Column filter type | Description |
Contains | Filters to cells which contain the entered text anywhere in the paragraph |
Does not contain | Filters to cells which do not contain the entered text anywhere in the paragraph |
Starts with | Filters to cells which contain the entered text at the beginning of the paragraph |
Ends with | Filters to cells which contain the entered text at the end of the paragraph |
Equals | Filters to cells which exactly contain the entered text |
Does not equal | Filters to cells which do not exactly contain the entered text |
Is empty | Filters to cells which do not contain any text |
Is not empty | Filters to cells which contain any text |
Unique column filters
Some column filter types are unique to a specific column type. Magic columns like Sign Offs have unique filters available.

