Find a record by using a data form

Microsoft Office Excel 2003

  • To move through records one at a time, use the scroll bar arrows in the dialog box. To move through 10 records at a time, click the scroll bar between the arrows.
  • To move to the next record in the list, click Find Next. To move to the previous record in the list, click Find Prev.
  • To set search conditions, or comparison criteria, click Criteria, then enter the criteria into the data form. To find records that match the criteria, click Find Next or Find Prev. To return to the data form without searching for records based on the criteria you specified, click Form.
  • ShowWildcard characters you can use as criteria

    The following wildcard characters can be used as comparison criteria for filters, and when searching and replacing content.

    Use To find
    ? (question mark) Any single character
    For example, sm?th finds "smith" and "smyth"
    * (asterisk) Any number of characters
    For example, *east finds "Northeast" and "Southeast"
    ~ (tilde) followed by ?, *, or ~ A question mark, asterisk, or tilde
    For example, fy91~? finds "fy91?"