Microsoft Office Tutorials and References
In Depth Information
Selecting cells by searching
The Find and Replace dialog box is nonmodal, so it allows you to return to the worksheet without dismissing the
The Find and Replace dialog box supports two wildcard characters:
Matches any single character
Matches any number of characters
Wildcard characters also work with values when the Match Entire Cell Contents option is
selected. For example, searching for 3* locates all cells that contain a value that begins
with 3. Searching for 1?9 locates all three-digit entries that begin with 1 and end with 9.
Searching for *00 locates values that end with two zeros.
To search for a question mark or an asterisk, precede the character with a tilde (~). For example, the following search
string i nds the text *NONE* :
If you need to search for the tilde character, use two tildes.
If your searches don’t seem to be working correctly, double-check these three options
(which sometimes have a way of changing on their own):
Match case: If this check box is selected, the case of the text must match exactly.
For example, searching for smith does not locate Smith .
Match entire cell contents: If this check box is selected, a match occurs if the
cell contains only the search string (and nothing else). For example, searching for
Excel doesn’t locate a cell that contains Microsoft Excel . When using wildcard
characters, an exact match is not required.
Look in: This drop-down list has three options: Values, Formulas, and Comments.
If, for example, Values is selected, searching for 900 doesn’t ﬁ nd a cell that
contains 900 if that value is generated by a formula (unless the formula
itself contains 900 ).