How to Filter an Excel Database
by docnmail.com - Free Online Courses for Everyone

Free Excel Course

Simple Filters

• Introduction

• Data Form

• AutoFilter

• Uniques, Blanks...

• Display Top 10

• Custom Filters

• Match Selection

Advanced Filters

• Set up Worksheet

• Perform Filters

• Use Extract Range

Bookmark Course

More Free Courses:

Computer Courses

Excel Courses

Database Courses

All Topics

MS Excel books:
from Amazon.com

Excel 2003 Bible

Microsoft Office Excel 2003 Inside Out

Excel 2003 Formulas

Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.

 

Page 7 of 10

AutoFilter - Filter to Match Selection

Microsoft Excel AutoFilter ButtonYou may quickly see all the records in the same column that match a selection by clicking the AutoFilter button on the toolbar.

If the AutoFilter Button is not found on the toolbar, follow the directions below to add it.

Make sure that AutoFilter is shut off - Data>Filter>uncheck AutoFilter.

• Select a cell in the database (ie. A20 Harney Peak Trail System)

• Click the AutoFilter Button

The records that do not contain Harney Peak Trail System in column A are hidden.  Notice that the AutoFilter drop box arrows have appeared next to each of the headings.

Redisplay the whole database.  Data>Filter>Show All

Turn AutoFilter off Data>Filter>uncheck AutoFilter

Once you get the hang of using AutoFilters to perform filters, it'll most likely not be long before you'll want to apply criteria to multiple columns in filtering the database.  Advanced Filters make this possible, they are covered next.

To add the AutoFilter Button to the toolbar

• Click View on the Menu Bar

• Hover Toolbars & click Customize - the Customize dialog box appears.

• Click the Commands tab

• Click Data in the left hand box

• Scroll down to AutoFilter in the right box

 

Click and Drag (with the mouse button down) the AutoFilter Button out of the dialog box and up onto the tool bar next to the undo button. Release the mouse button & Close the Customize dialog box.


Next Page - Advanced Filters: Setting up the Worksheet >>

Online Courses
 Excel Basics for Beginners
This is a beginning class for students who have no experience with Excel.

Excel 2007
Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data.

 

 

Site Map  •  FAQs  •  Link to Us  •  Educational Gift Ideas  •  Add a Course  •  Contact Us

© 2008 Learning Link Finders, Inc. - All Rights Reserved - Modified on 01/01/08

All trademarks and registered trademarks appearing on the Docnmail.com website are the property of their respective owners.
By providing links to other sites, Learning Link Finders, Inc. does not guarantee, approve or endorse the information or products available
at these sites, nor does a link indicate any association with or endorsement by the linked site to Docnmail.com.