Microsoft Office Tutorials and References
In Depth Information
To Toggle a Filter
The following step toggles the ﬁ lter to redisplay all records.
• Click the Toggle Filter button
on the Home tab to toggle the
ﬁ lter and redisplay all records
Does that action clear the ﬁ lter?
No. The ﬁ lter is still in place. If
you click the Toggle Filter button
a second time, you again will see
only the ﬁ ltered records.
all records once
data is not ﬁ ltered
T O C LEAR A F ILTER
Once you have ﬁ nished using a ﬁ lter, you can clear the ﬁ lter. After doing so, you
no longer will be able to use the ﬁ lter by pressing the Toggle Filter button. To clear a
ﬁ lter, you use the following steps.
1. Click the Advanced button on the Home tab.
2. Click Clear All Filters on the Advanced menu.
Using Wildcards in
Both the question mark
(?) and the asterisk (*)
wildcards can be used
in ﬁ lters created using