Filtering a Database

When you need to find records in a database that match the terms you specify, you can filter it quickly using Excel's AutoFilter feature. Filtering makes Excel display only the records that match your search terms, hiding all the other records.

NOTE: You can also search for records by using Excel's Find feature. Choose Home images Editing images Find & Select images Find or press Ctrl+F to display the Find and Replace dialog box, type your search ...

Get Office 2010 Made Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.