Microsoft Office Tutorials and References
In Depth Information
Find and Replace Data
The Find and Replace dialog box
appears, displaying the Replace tab.
4 Type the data that you want to
5 Type the replacement data.
6 Click Find Next .
Excel locates the first occurrence
of the data.
7 Click Replace to replace it.
You can click Replace All to
replace every occurrence in the
Excel replaces the data with the
text you typed.
Excel selects the next instance of
8 When finished, click Close .
Excel may display a prompt box when the
last occurrence is found. Click
Where can I find detailed
You can click the Options button
in the Find and Replace dialog
box to reveal additional search
options. For example, you can
search by rows or columns,
matching data, and more. You
can also search for specific
formatting or special characters
using Format options. To hide the additional search options,
click the Options button again.
How can I search for and delete
You can search for a particular word,
number, or phrase using the Find and
Replace dialog box, and remove the
data completely from the worksheet.
Start by typing the text in the Find what
field; then leave the Replace with field
empty. When you activate the search,
Excel looks for the data and deletes it
without adding new data to the