Filtering data using AutoFilter

The AutoFilter feature offers a simple way of displaying only those data you require.

Note: In order to be able to use all functions, Advanced options by preset must be enabled.

1. Click to enable the feature.
2. Click the button next to a column name. Check boxes will now appear next to the columns.
3. Select the check boxes for the data you want to see. You can select multiple items in multiple columns. The more items you select, the more refined the selection will be.

To cancel the AutoFilter in order to display all records, click again.

Tip: Open the View menu and select Show filter box to display the active filter on the status bar.

More AutoFilter options

The list of check boxes also contains other items. These items can be used for each column as follows:

• (All): Select to disable the AutoFilter for the column.
• (Custom...): Select this item to enter the conditions the data must meet, for example 'equals' '5000'. First choose a name and then type a value. If desired, you can add another condition on the line below. Select 'AND' if the data must meet both conditions. Select 'OR' if the data should meet just one of the conditions.
• (Blanks): Select to display only records that do not have a value in this column. This will allow you to fill any fields that have been left blank unintentionally.
• (NonBlanks): Select if you do not want to see any lines that do not have a value in this column.