O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required