Microsoft Office Tutorials and References
In Depth Information
Seek and Ye Shall Find . . .
in the Find
When you search for a text entry with the Find and Replace feature, be
mindful of whether the text or number you enter in the Find What text box is
separate in its cell or occurs as part of another word or value. For example, if you
enter the characters in in the Find What text box and you don’t select the
Match Entire Cell Contents check box, Excel finds
✓ The In in Regional Income 2010 in cell A1
✓ The In in International in A8, A16, A24 and so on
✓ The in in Total Operating Expenses in cell A25
If you select the Match Entire Cell Contents check box in the Find and
Replace dialog box before starting the search, Excel would not consider the
anything in the sheet to be a match because all entries have other text
surrounding the text you’re searching for. If you had the state abbreviation for
Indiana (IN) in a cell by itself and had chosen the Match Entire Cell Contents
option, Excel would find that cell.
When you search for text, you can also specify whether you want Excel to
match the case you use (uppercase or lowercase) when entering the search
text in the Find What text box. By default, Excel ignores case differences
between text in cells of your worksheet and the search text you enter in the
Find What text box. To conduct a case-sensitive search, you need to select
the Match Case check box (available when you click the Options button to
expand the Find and Replace dialog box, shown in Figure 6-10).
If the text or values that you want to locate in the worksheet have special
formatting, you can specify the formatting to match when conducting the search.
To have Excel match the formatting assigned to a particular cell in the
worksheet, follow these steps:
1. Click the drop-down button on the right of the Format button in the
Find and Replace dialog box and choose the Choose Format from Cell
option on the pop-up menu.
Excel opens the Find Format dialog box.