Microsoft Office Tutorials and References
In Depth Information
Filter Data
Filter
Data
When using Excel as a database, you can use an
AutoFilter to view only portions of your data. Unlike
a sort, which sorts the entire table, a filter selects
certain records to display based on your criteria, while
hiding records that do not match the criteria. (Refer to
the previous section to learn how to sort data in Excel.)
I LT E R
0
Filter Data
1 Select the field names for the data
you want to filter.
2 Click the Home tab on the
Ribbon.
3 Click the Sort & Filter button.
4 Click Filter .
2
3
4
1
Excel adds drop-down arrow
buttons ( ) to your field names.
5 Click a field’s
.
5
180
Search JabSto ::




Custom Search