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

Free Excel Course

• Introduction

• Data Form

• AutoFilter

• Uniques, Blanks...

• Display Top 10

• Custom Filters

• Match Selection

Advanced Filters

• Set up Worksheet

• Perform Filters

• Use Extract Range

More Free Courses:

Computer Courses

Excel Courses

Database Courses

All Topics

MS Excel books:
from Amazon.com

Excel 2003 Formulas

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

 

Page 3 of 10

Excel AutoFilter

Excel includes an AutoFilter feature that makes finding groups of records conforming to criteria very easy.  The group of records is then at your disposal for editing, copying, etc.  Keep in mind that the records are still part of the original database, it's just that the rows of data that do not meet the given criteria are hidden.  The hidden rows may be seen at any time by using the Data>Filter>Show All command.

Like the Data Table feature, AutoFilter is easy to execute.

• Click any cell of the database

• Click Data and hover the mouse pointer over Filter

• Click AutoFilter from the submenu

AutoFilter drop boxes appear on the right side of each Heading cell.  Upon clicking each of the arrows, you'll see that every unique entry contained in the corresponding column of data has been included in the options of the drop box.  Excel adds up to five additional choices.  They are All, Top 10, Custom, Blanks, and Non-Blanks.  Blanks and Non-Blanks are included in the list only if there is a blank cell in the corresponding column of data (i.e. Column C of the Black Hills Trails database).  The following filters may be performed using the AutoFilter Arrow drop boxes: Unique Entry, Top Ten, Custom, Blanks, and Non-Blanks.  Each is discussed in detail on the next few pages.

Next Page - AutoFilter - Unique entries, Blanks & Non-Blanks >>

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.