Microsoft Office Tutorials and References
In Depth Information
FIND AND REPLACE
Cells can contain numbers, text, comments, formats,
and formulas. With Excel, you can search for any
of these elements to view them, replace them, or
perform some other action. You may, for example,
find and replace values to correct mistakes, or perhaps
you need to return to a value to add a comment or
The Excel Find and Replace dialog box is available on
the Home tab in the Editing group or by pressing
Ctrl+H. The Find feature is part of Find and Replace
and is available on the Home tab in the Editing group
or by pressing Ctrl+F.
To find and replace formats, specify what you are
seeking and with what you want to replace the item
you are seeking. Click the Options button in the Find
and Replace dialog box to specify additional details.
Use the Within drop-down menu to indicate whether
to search the current worksheet or the current
workbook. Click the Formatting button to restrict
your search to characters formatted in a certain way,
such as bold or percentages.
Click the Home tab.
Click Find & Select in the Editing
A menu appears.
Alternatively, you can press
Ctrl+H to open the Find and
Replace dialog box.
l The Find and Replace dialog box
Click Options if your dialog box
does not look like the one shown
Note: The Options button allows
you to toggle between the short
and long form of the dialog box.
Click here and select Choose
Format from Cell.