This chapter is from the book
This chapter is from the book
This chapter is from the book
Finding and Replacing Text
At times, you might need to change a word or phrase that’s used throughout a document. The Find and Replace dialog box makes it easy to replace text, especially in long documents.
On the Home tab, click the Replace button.
In the Find and Replace dialog box, enter the text you’re searching for in the Find What box.
Enter the replacement text in the Replace With box.
Click the Replace button to make the replacement.
NOTEFinding Text If you don’t want to approve each instance of a replacement, you can click the Replace All button to handle this process all at once.
NOTEExcel Navigation In Excel, click the Find & Select button, and select Replace from the menu to open the Find and Replace dialog box.
Office notifies you when the process is finished. Click OK to close the notification.
Click the Close button to close the Find and Replace dialog box.
)
)
NOTE
Finding Text Just want to find specific text rather than replace it? Enter the text in the Find What box, and click the Find Next button. You can also click the Find button on the Home tab to perform a search.
NOTE
More Options Click the More button to display more find-and-replace options. For example, you might want to replace only text with matching case or search only for whole words.