Apple Numbers '09 - Manual (Page 133)

Chapter 6 Using Formulas in Tables 133
Choose View > Show Formula List and click Find & Replace. m
Find: Type the formula element (cell reference, operator, function, and so on) you
want to find.
In: Choose Formulas Only from this pop-up menu.
Match case: Select to find only elements whose uppercase and lowercase letters
match exactly what’s in the Find field.
Whole words: Select to find only elements whose entire contents match what’s in the
Find field.
Replace: Optionally type what you want to use to replace what’s in the Find field.
Repeat search (loop): Select to continue looking for what’s in the Find field even after
the entire spreadsheet has been searched.
Next or Previous: Click to search for the next or previous instance of what’s in the Find
field. 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 field with what’s in the
Replace field.
Replace: Click to replace the current instance of what’s in the Find field with what’s in
the Replace field.
Replace & Find: Click to replace the current instance of what’s in the Find field and to
locate the next instance.