Adding a filter line

In the Filter window, add filter lines to create criteria for your filter. Each line represents a unique criterion or filter expression.

Before you begin

You must create your filter and be in the Filter window to add a filter line.

Procedure

  1. Click the Add a Filter Line icon.
    The Edit Filter window appears.
  2. Edit the expression.
    Click a data item, then click a Boolean operator, and then enter a constant or enter the cell reference that contains the value you want to use in this expression.
  3. Click OK.