Microsoft Office Tutorials and References
In Depth Information
Finding and Replacing
Finding and Replacing
Lengthy, complex business ﬁ les can hold a ton of information, and who wants to spend all
day using the Page Down key and scrolling to try to ﬁ nd one bit of information? Luckily,
you can use the Find feature to search for a particular word or phrase. For example, if you
need to ﬁ nd the section of a construction contract that deals with site remediation, you
can ﬁ nd the phrase “site remediation.” Even better, you can use the Replace feature to
correct words you’ve misspelled or to change phrases or names. For example, if you’ve
mistakenly spelled Artur Consulting as Arthur Consulting throughout a proposal for a new client,
you can replace all instances of the spelling boo-boo with the correction.
Find and Replace work in a very similar fashion, so you can use the following steps for
1. Press Ctrl+Home. This step moves the insertion point to the beginning of the
document so that the Find or Replace operation starts from the top.
2. Click the Home tab on the Ribbon.
3. Click Replace in the Editing group. The Find and Replace dialog box appears. The
Replace tab that appears for a ﬁ nd includes a Find what text box and a Replace
with text box.
In Excel, click the Find & Select button in the Editing group on the Home tab, and then click Replace. In Word,
clicking Find opens the Navigation pane at the left; type a term to i nd in the text box at the top, and Word highlights all
matches in the document. In most office applications, you also can press Ctrl+F to start a i nd. The Find and Replace
dialog box varies in appearance from application to application.
4. Type the entry to ﬁ nd in the Find what text box.
5. Type the replacement entry, if any, in the Replace with text box.
6. Specify additional options, if needed. The available options vary depending on
the application. For example, in Word, you can click the More button and then
specify choices such as matching case or matching a preﬁ x or sufﬁ x.
7. Click Find Next. The application highlights the ﬁ rst matching instance of the
search word or phrase, as shown in Figure 3.23.