AutoFilter, AutoFilter Out, and Filter This One
AutoFilter
Please read the help file material about Filters and understand what Filtering is before reading this section.
Auto Filtering is a convenient way of applying a filter if you only have a single filter criterion. In the case of a single filter criterion, it is cumbersome to bring up the Filter dialog and fill out the form.
To use Auto Filtering, simply find a coin in the Main Window that already has the criterion you wish to filter for. Left-single-click your mouse in a cell that contains that criterion. Here are some examples:
Once the cell is highlighted that contains the desired filter criterion, click the "AutoFilter" button at the left. The selected filtering criterion will be imposed.
The "Remove All Filters" button is activated when an Auto Filter is imposed - click it to view the entire list of available coins unfiltered.
As with regular filters, AutoFilters are cumulative. That means that if you are viewing a filtered list of coins and you add another filter then you filter the already filtered list - you don't remove the current filter first. If you intend to remove the current filters first, remember to press "Remove All Filters".
AutoFilter Out works the same way that Auto Filter does, except that where Auto Filter only keeps those coins that match the selected criterion AutoFilter Out only keeps those coins that do not match the selected criterion.
For example, if you click on any cell in the Year column that contains 1866 and then select AutoFilter Out, all of the 1866 coins will be removed from the view.
AutoFilter Out is cumulative with other filters in exactly the same way as AutoFilter.
Filter This One is a very simple filter. Highlight any cell in any row, click on Filter This One, and the row that contains the selected cell is removed from the database. This is useful if you are attributing a coin and gradually narrowing down the possibilities. You can remove eliminated possibilities with this command one by one.
Filter This One is cumulative with all other filters.