You can choose to display only those rows that meet certain criteria in one or more columns.

1. Select one or more columns, and choose .

Or, right-click the desired column(s). From the context menu, choose Set Filter.

2. The dialog box Filter criteria appears, as in the following example:



3. Enter the From/To values for each column selected.

• To include more than one value or range for a column, choose . In the subsequent dialog box, enter the single values or ranges on the tab(s) with the green traffic light. Choose .
• To exclude a value or range from the display, choose . In the subsequent dialog box, enter the single values or ranges on the tab(s) with the red traffic light. Choose .
• To delete a filter criterion, select the appropriate line, and choose .
• To delete all entries for the filter, choose .
• To copy the filter criteria and exit the dialog box, choose Execute.

If you have set a filter without having selected a column first, the following dialog box appears:

You define the filter criteria, and proceed as described in step 3.

In the column heading of every column for which you have set a filter, a small filter icon appears, as in this example:

To go back to the prefiltered list display, single-click the dropdown arrow beside the filter icon , and choose Delete filter.

In the full-screen mode, choose Edit ® Delete filter.