Microsoft Office Tutorials and References
In Depth Information
More About AutoFilter
More About AutoFilter
Other important points regarding AutoFilter include the following:
1. When AutoFilter is enabled and records are hidden, Excel displays a fi lter icon in
the table column heading arrows used to establish the fi 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 fi lter criterion for a single fi eld, select the Select All option from the
column heading AutoFilter menu for that fi eld.
4. When you create a formula in the total row of a table, the formula automatically
recalculates the values even when you fi 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
fi lter to the table.
5. You can fi 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).
Protected Worksheets
The Sort, Subtotal, and
AutoFilter commands
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.
To Show All Records in a Table
The following steps illustrate how to show all records in the table following a query.
1
With the table
active, click the Data
tab on the Ribbon
and then point to
the Filter button
on the Ribbon
(Figure 5–53).
Data tab
Filter
button
2
Click the Filter
button on the
Ribbon to display
all of the records in
the table.
Other Ways
1. Press ALT + A , T
2. Click column heading
arrow that includes a
fi lter icon, click (Select
All) in AutoFilter menu
Figure 5–53
 
 
Search JabSto ::




Custom Search