Microsoft Office Tutorials and References
In Depth Information
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
1 Select the field names for the data
you want to filter.
2 Click the Home tab on the
3 Click the Sort & Filter button.
4 Click Filter .
Excel adds drop-down arrow
buttons ( ) to your field names.
5 Click a field’s