Datasheet

To create a custom AutoFilter, take the following steps:
1. Turn on the Excel Filters.
As I mention earlier in this section, filtering is probably already on
because you’ve created a table. However, if filtering isn’t turned on,
select the table and then choose Data➪Filter.
2. Select the field that you want to use for your custom AutoFilter.
To indicate which field you want to use, open the filtering drop-down list
for that field to display the table menu, select Text Filters, and then
select a filtering option. When you do this, Excel displays the Custom
AutoFilter dialog box. (Refer to Figure 1-13.)
3. Describe the AutoFilter operation.
To describe your AutoFilter, you need to identify (or confirm) the filter-
ing operation and the filter criteria. Use the left-side set of drop-down
lists to select a filtering option. For example, in Figure 1-15, the filtering
option selected in the first Custom AutoFilter set of dialog boxes is
Begins With. If you open this drop-down list, you’ll see that Excel pro-
vides a series of filtering options:
• Begins With
• Equals
• Does Not Equal
• Is Greater Than or Equal To
• Is Less Than
• Is Less Than or Equal To
• Begins With
• Does Not Begin With
• Ends With
• Does Not End With
• Contains
• Does Not Contain
Figure 1-13:
The Custom
AutoFilter
dialog box.
24
Part I: Where’s the Beef?
05_045992 ch01.qxp 1/18/07 5:45 PM Page 24