Apple Numbers '09 - Manual (Page 192)

You can also hold down the Control key and click a misspelled word. From the pop-up
menu you can choose an optional alternative spelling, click Learn, or click Ignore.
Searching for and Replacing Text
You can find every instance of a word or phrase in your spreadsheet and optionally
change it to something else. To learn how to find and optionally replace formula
elements, see “Finding and Replacing Formula Elements” on page 132.
Here are ways to find and replace text:
To search for text in a spreadsheet, choose Edit > Find > Show Search to open the
m
Search window.
In the search field, type the text you want to search for. Optionally click the disclosure
triangle in the search field and choose Match Case and/or Whole Words to constrain
the search results.
When search results are listed in the window, select one to highlight it in
the spreadsheet.
To redisplay search results for any of the last 10 searches, choose a search string from
the search field pop-up menu under Recent Searches.
To find text in a spreadsheet or in the current sheet and optionally replace it with
m
different text, choose Edit > Find > Show Search and then click Find & Replace.
Find: Type the text you want to find.
In: Choose Entire Document or Current Sheet Only from this pop-up menu to set the
scope of the find operation.
Match case: Select to find only text with uppercase and lowercase letters that match
exactly what’s in the Find field.
192 Chapter 8 Working with Text