Apply Excel Style Filters

Excel style filters can also be applied. To activate this facility, check the Excel style filtering checkbox in the Grid Options section of the View Tab. The Column filtering checkbox must be checked before the Excel style filtering checkbox is checked.

To apply an Excel style filter to a column, hover the cursor over the filter row field for that column and click on the button that is then displayed at the end of the field.

The following window is then displayed:

The window lists all the values in the column, plus All and Blanks.

Next to each item in the list there is a checkbox. To filter out a value from the column, uncheck its checkbox. To uncheck all values, uncheck the All checkbox. Check the All checkbox again to check all the checkboxes again.

If the Blanks checkbox is checked, rows without a value in the column are displayed when the filter is applied.

When the required filter conditions have been selected, click OK to close the window and apply the filter.

The filter is then applied. The value that the column is being filtered by is displayed in the filtering row field for the column. If the column is being filtered by multiple values or by and a text filter, Custom is displayed.

To edit an Excel style filter, access the Excel style window filter again and change the filter criteria as required. To clear the filter, click Clear Filter. Refer to Removing Filtering.

Text Filters

More advanced filters can be applied by clicking Text Filters. A list of text filtering criteria is then display, plus Custom Filter.

Click on the required criterion. The advanced filtering window is then displayed with the selected criterion selected in the Criteria field and the current column selected in the Field field.

If the Custom Filter option is selected, the advanced filtering window is displayed without the Criteria field being completed.

Refer to Apply Advanced Grid Filters for further information.