Microsoft Office Tutorials and References
In Depth Information
Find Text in a Workbook
Dealing with Workbooks
A Excel selects the next cell
that contains an instance
of the search text.
Note: If the search text
does not exist in the
document, Excel displays a
dialog box to let you know.
6 If the selected instance is
not the one you want, click
Find Next until Excel finds
the correct instance.
7 Click Close to close the
Find and Replace dialog
B Excel leaves the cell
When I search for a particular term, Excel
only looks in the current worksheet. How
can I get Excel to search the entire
In the Find and Replace dialog box, click
Options to expand the dialog box. Click
the Within and then click Workbook .
This option tells Excel to examine the
entire workbook for your search text.
When I search for a name such as Bill, Excel also
matches the non-name bill. Is there a way to fix
Yes. In the Find and Replace dialog box, click
Options to expand the dialog box. Select the
Match case check box ( changes to ). This
tells Excel to match the search text only if it has
the same mix of uppercase and lowercase letters
that you specify in the Find what text box.