![](https://help.apple.com/assets/65E6147D8DB35658D705D520/65E6147EDB981F66D60777AA/en_US/38bdd020791c0921af2389610de1e236.png)
Find and replace text in Numbers for iCloud
You can search for specific words, phrases, numbers, and characters, and automatically replace search results with new content that you specify. Text in all tables, text boxes, shapes, and image captions is included in the search.
Search for specific text
Click the View button
in the toolbar, then choose Show Find & Replace.
You can also press Command-F (on a Mac) or Control-F (on a Windows computer).
Note: In a shared spreadsheet set to View Only, click the Find button
in the toolbar.
In the Find field, enter a word or phrase you want to find.
Matches are highlighted as you enter text.
To refine your search, click the Settings button
to the left of the Find field, then do any of the following:
Find words matching the capitalization of the text you entered: Choose Match Case.
Restrict search results to whole words: Choose Whole Words.
For example, searching for under with Whole Words selected won’t find the word underline.
Click the arrows to the right of the Find field to select the next or previous instance of text that matches your search.
To change the text, double-click the highlighted text, then type.
When you’re finished, click Done (or press the Esc key on your keyboard).
Search for and replace text
You can search for specific text and replace one or more instances with the text you specify.
Click the View button
in the toolbar, then choose Show Find & Replace.
You can also press Command-F (on a Mac) or Control-F (on a Windows computer).
Note: In a shared spreadsheet set to View Only, click the Find button
in the toolbar. You can search for but not replace a word or phrase.
Click the Settings button
to the left of the Find field, then choose Find & Replace.
You can also choose other options, such as Whole Words and Match Case, to refine your search.
In the Find field, enter a word or phrase you want to find.
As you enter text, matches are highlighted. The first match is selected and highlighted in yellow.
In the Replace field, enter the replacement word or phrase.
Important: If you leave the Replace field blank, all instances of the text are deleted when you replace the found text. (If necessary, click the Undo or Redo buttons in the toolbar.)
Click the arrows to select the next or previous instance of text that matches your search.
When the text you want to change is highlighted, click Replace.
When you’re finished, click Done (or press the Esc key on your keyboard).