Filtering Text in Excel 2008-2011 for Mac

Filtering Text in Excel 2008-2011 for Mac

  1. Click a cell in the range or table that you want to filter.
  2. On the Standard toolbar, click Filter Filter button, standard toolbar.
  3. Click the arrow AutoFilter arrow in the column that contains the content that you want to filter.
  4. Under Filter, click Choose One, and then in the pop-up menu, do one of the following:
To filter the range for Click
Rows that contain specific text Contains or Equals.
Rows that do not contain specific text Does Not contain or Does Not equal.
  1. In the box next to the pop-up menu, enter the text that you want to use.
  2. Depending on your choice, you may be offered additional criteria to select:

Filter criteria

To Click
Filter the table column or selection so that both criteria must be true And.
Filter the table column or selection so that either or both criteria can be true Or.