Click
in the toolbar, then select Show Find and Replace.
Click the pop-up menu to the left of the top text field, then choose Find & Replace.
Enter a word or phrase in the top text field.
As you enter text, the number of matches appears alongside it. The first match you can edit is highlighted in yellow.
Do any of the following:
Replace all matches with the same replacement text: In the bottom text field, enter replacement text, then click Replace All.
Important: Leaving the bottom text field blank deletes all instances of the found text.
Replace different matches with different text: In the bottom text field, enter replacement text, then click Replace & Find. Continue clicking Replace & Find to apply the same replacement text, or enter different replacement text and click Replace & Find.
Replace the selected match but don’t move to the next match: Click Replace.
Move to the previous or next match without making a change: Click the left or right arrow.
In a table cell, replacing a table value updates both the displayed value and the underlying value. For example, if you replace “1/2” with “1/3”, the underlying value changes from “0.5” to “0.333333”.
You can’t replace matching text in table cells that contain a formula.