Find a record by using a data form

From Microsoft Office Excel 2003

previous page next page

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.

Wildcard 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?"

previous page start next page