Microsoft Office Tutorials and References
In Depth Information
More About AutoFilter
Other important points regarding AutoFilter include the following:
1. When AutoFilter is enabled and records are hidden, Excel displays a ﬁ lter icon in
the table column heading arrows used to establish the ﬁ lter and the row headings
of the selected records in blue.
2. If the column heading arrows do not show, then you must manually enable
AutoFilter by clicking the Filter command on the Sort & Filter menu on the Home
tab on the Ribbon. The Filter button also is on the Data tab on the Ribbon.
3. To remove a ﬁ lter criterion for a single ﬁ eld, select the Select All option from the
column heading AutoFilter menu for that ﬁ eld.
4. When you create a formula in the total row of a table, the formula automatically
recalculates the values even when you ﬁ lter the list. For example, the results shown
in the total row in Figure 5–31 on page EX 366 automatically update if you apply a
ﬁ lter to the table.
5. You can ﬁ lter and sort a column by color or conditional formatting using the Sort
by Color and Filter by Color commands on the AutoFilter menu (Figure 5–51 on
the previous page).
The Sort, Subtotal, and
are unavailable if the
worksheet or workbook
is protected, unless you
selected them in the
‘Allows users of this
worksheet to‘ list in the
Protect Sheet dialog box
when you protect the
worksheet or workbook.
The following steps illustrate how to show all records in the table following a query.
• With the table
active, click the Data
tab on the Ribbon
and then point to
the Filter button
on the Ribbon
• Click the Filter
button on the
Ribbon to display
all of the records in
1. Press ALT + A , T
2. Click column heading
arrow that includes a
ﬁ lter icon, click (Select
All) in AutoFilter menu