About finding data
The Find what feature (Commands and Options
dialog box, Sheet tab) can locate text, numbers, dates, and times that have been entered directly into cells or that are the results of formulas.
Keep
the following guidelines in mind when using Find what options:
- Match case By default, Find what is not case sensitive. To find only those
cells with values that match the case of your entry, select the Match
case check box.
- Entire cell only By default, Find what searches for cells that
include the
value you enter in the Find what box. For example, an entry of
"John" finds cells with strings such as "Johnson"
or "Little John." To find cells that contain only the value
you entered and nothing else, select the Entire cell only check
box.
- Formatted values The Find what feature searches for
displayed values, not formats. For example, suppose a cell is formatted with the Yes/No number format. If the cell contains a zero (0), the cell displays the word
No,
and you can use Find what to locate the phrase "No". You can't use Find
what to find all cells formatted with a
particular color or font.
- Search direction The Find what feature searches from left to right across the columns of the first row, and then
from
left to right across the columns of the second row, and so on.
- Wildcard characters The Find what
feature does not allow
wildcard characters such as question
mark (?) and asterisk (*).
- Hidden data The Find what feature does not find data in hidden cells or
cells hidden by
filtering.