Apply or remove a filter

Apply a filter

  1. Click a cell within the list that you want to filter, or select the specific range of cells that you want to filter.
  2. On the toolbar, click AutoFilter so that it is selected.
  3. Click the arrow in the column that contains the data you want to display.
  4. To display only the items you want to see, clear the Show All check box, and then select the check box for each item you want to display.

Remove a filter