			SELECT A TOPIC
	Excel 2000		Working with Databases		Filtering specific record groups

Filtering specific record groups

A database is a list or table of information, consisting of Column Labels (data categories — e.g. name, address, age) and Records (information unique to each person or item in the database).

Suppose you have a large database and need to search that database for a specific record. You can do this using a filter. In this example, we use a filter to find people whose last name is Smith.


1.	Click any cell inside the database table, then choose Filter\|AutoFilter from the Data menu.
2.	Click next to a field header (e.g. LastName), then select a group criteria (e.g. Smith). The down arrow in filtered columns turns blue . If required, you can filter multiple columns.

To remove filtering: click on the field header(s) and choose (All). Alternatively, choose Filter|AutoFilter from the Data menu.