Microsoft Office Tutorials and References
In Depth Information
Find and Replace Data
Find and
Replace Data
You can use Excel’s Find tool to search through
your worksheet for a particular number, formula,
word, or phrase. You can use the Replace tool to
replace instances of text or numbers with other
data. For example, you may need to sort through
a long worksheet to replace a reference with
another name.
Find and Replace Data
Find Data
1 Click the Home tab on the
Ribbon.
2 Click the Find & Select button.
3 Click Find .
The Find and Replace dialog box
appears, displaying the Find tab.
4 Type the data that you want to
find.
5 Click Find Next .
1
2
3
4
6
Excel searches the worksheet
and finds the first occurrence
of the data.
5
1
You can click Find Next again to
search for the next occurrence.
6 When finished, click Close to
close the dialog box.
Note:
2
3
Excel may display a prompt box when the
last occurrence is found. Click
OK
.
Replace Data
1 Click the Home tab on the
Ribbon.
2 Click the Find & Select button.
3 Click Replace .
176
 
Search JabSto ::




Custom Search