User Guide
To nd text in a spreadsheet or in the current sheet and optionally replace it with m
dierent text, choose Edit > Find > Show Search and then click Find & Replace.
Find: Type the text you want to nd.
In: Choose Entire Document or Current Sheet Only from this pop-up menu to set the
scope of the nd operation.
Match case: Select to nd only text with uppercase and lowercase letters that match
exactly what’s in the Find eld.
Whole words: Select to nd only text that matches what’s in the Find eld in its
entirety.
Replace: Type replacement text in this eld.
Repeat search (loop): Select to continue looking for what’s in the Find eld even after
the entire spreadsheet or sheet has been searched.
Next or Previous: Click to search for the next or previous instance of what’s in the Find
eld. When an element is found, the Formula Editor opens and displays the formula
containing the instance of the element.
Replace All: Click to replace all instances of what’s in the Find eld with what’s in the
Replace eld.
Replace: Click to replace the current instance of what’s in the Find eld with what’s in
the Replace eld.
Replace & Find: Click to replace the current instance of what’s in the Find eld and to
locate the next instance.
Use the other commands on the Edit > Find submenu for additional operations. m
Find Next or Find Previous: Finds the next or previous occurrence of the current
Find text without replacing it, starting with the current sheet or selected cell(s) and
proceeding forward or backward through the spreadsheet.
Use selection for Find: Finds the next occurrence of the selected text.
Jump to Selection: Displays the selected text when it’s not currently in view.
19 0 Chapter 8 Working with Text