This topic summarizes how the end user can interact with the simple row filtering feature.

Once you have row filtering applied to a column, an indicator appears in the column header as in the following figure:

If you want to display a label for the header, you must add another row of column headers and put the label in that row.

The column header displays the row filtering indicator, a drop-down arrow symbol. Clicking on this indicator provides a drop-down list of the filter choices. Picking an item from this list causes that filter to be applied and all the rows meeting that condition (in this column) are filtered. The default drop-down list contains all the unique text values in cells in this column. The figure below shows an example of a drop-down list of filters:

The table below summarizes the entries in the drop-down list.

Filter List Item	Description
(All)	Include or allow all the rows in this column regardless of content
[contents]	Include or allow only those rows with this particular cell content in this column
(Blanks)	Include or allow only rows that have blanks (empty cells) in this column
(NonBlanks)	Include or allow only rows that have non-blanks (non-empty cells) in this column, in other words any cell that has any content

You can customize the filter list. For more information, see Customizing the List of Filter Items.

Using Code

Create a named style and then set the style row filter.

Example

This example code sets a style row filter.