The AutoFilter feature offers an easy way of displaying only those data you require.
Click to enable the feature.
Click .
Check boxes will appear above the column.
Select the check boxes next to the data you want to display. 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 this item to cancel the AutoFilter for the column.
(Custom...): Select this item to enter any 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 this item to display only records without any value in this column. This will allow you to fill any fields that have been left blank unintentionally.
(NonBlanks): Select this item to hide all lines that do not have a value in this column.
to enable the feature.
.
