Auto filter

We will use a simple example to demonstrate how to use Auto Filter.

You have a column of sales figures in the range B11..B22, headed by a label (Sales $) in B10. A column of months (January to December) in the range A11..A22 precedes the Sales column and is headed by a label, Months, in A10.

To select all of the rows with a value greater than a certain value in the Sales column, for example, $10,000, do the following:

  1. Select the Sales column, including the label, using your mouse.

  2. Select Filter and then Auto Filter from the Data menu. This puts a box with a drop-down list at the top of the selected range i.e. in this case in the Sales cell.

  3. Click on the arrow to access the drop-down list and then choose from the following:

  1. To show all records after you have applied a filter, select Show All from the Data/Filter menu.

  2. To cancel a filter, select Auto Filter from the Data/Filter menu to switch if off.

See also: Advanced filter