• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part VI: Managing Lists or Databases > Finding, Filtering, and Editing Lists or...

Chapter 38. Finding, Filtering, and Editing Lists or Databases

  • Use the data form to find and edit data

    This section demonstrates some of the benefits of using the automatic data form for locating, viewing, and editing your list data.

  • Create simple criteria with AutoFilter

    This section demonstrates how easy it is to filter out or hide information that doesn't match your criteria.

  • Use wild cards and formulas to create complex criteria to filter data

    This section explains how to specify criteria using wild cards and formulas working with AutoFilter.

  • Produce complex criteria using advanced filters

    This section explains how to use the Advanced Filter command to set up more complex criteria than are supported by AutoFilter by taking advantage of a criteria range.

Lists or databases are used most frequently to find or analyze a collection of information. Finding data in a list or database involves selecting the row or rows of information satisfying some criteria, a set of questions, that you asked. Frequently, you will want to see all the rows of information that satisfy criteria. In Excel, you can also filter a list or database. Filtering temporarily hides all rows in the list that do not satisfy the criteria. After performing a filter, your list collapses to show only the row(s) satisfying the criteria you specified.


In Excel, the term database is generally the same as list, and the Data menu provides list management features that are analogous to the database management features in Excel 4 and earlier versions.

In Excel, you can find or filter data by using three mechanisms: the data form, the AutoFilter, or the Advanced Filter. The data form is an easy way to search for and edit individual records. The AutoFilter is a very easy way of collapsing a list to show only the row(s) satisfying your questions. The Advanced Filter is only slightly more complex, but enables you to ask very complex questions that must satisfy multiple conditions and even calculated criteria.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint