Datasheet

Undoing a filter
To remove an AutoFilter, display the table menu by clicking a drop-down list’s
button. Then choose the Clear Filter command from the table menu.
Turning off filter
The Data➪Filter command is actually a toggle switch. When filtering is turned
on, Excel turns the header row of the table into a row of drop-down lists. When
you turn off filtering, Excel removes the drop-down list functionality. To turn off
filtering and remove the Filter drop-down lists, simply choose Data➪Filter.
Using the custom AutoFilter
You can also construct a custom AutoFilter. To do this, select the Text Filter
command from the table menu and choose one of its text filtering options. No
matter which text filtering option you pick, Excel displays the Custom AutoFilter
dialog box, as shown in Figure 1-13. This dialog box enables you to specify with
great precision what records you want to appear on your filtered list.
Figure 1-12:
Sams and
Sams alone.
23
Chapter 1: Introducing Excel Tables
05_045992 ch01.qxp 1/18/07 5:45 PM Page 23