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
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
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
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.
Working with Text
Working with Text
Whole words: Select to find only text that matches what’s in the Find field in
Replace: Type replacement text in this field.
Repeat search (loop): Select to continue looking for what’s in the Find field 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
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: 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.
Use the other commands on the Edit > Find submenu for additional operations.
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.
Learn how to add images, shapes, sound, and movies to your
An object is any item you add to a spreadsheet and then manipulate. Images, shapes,
movies, text boxes, tables, and charts are all objects.
This chapter focuses on images (photographs or PDF files), shapes, sound, and movies.
Many of the techniques covered in this chapter for placing and manipulating these
objects can be generalized to tables, charts, and text boxes; any special formatting
techniques for these objects are covered in other chapters.
Working with Images
Numbers accepts all QuickTime-supported formats, including the following graphics
If you intend to greatly enlarge or reduce an image’s dimensions, consider converting
it to a PDF file before importing it. PDF files don’t lose their crispness when they’re
significantly resized; other file types may not retain their clarity as well when they’re
resized. You can convert an image to a PDF by using Grab. Open Grab (it’s in the
Applications/Utilities folder), choose Capture > Selection to capture an image, and
then choose File > Print to save the image as a PDF.
To import an image, do any of the following:
Choose Insert > Choose, select the file, and then click Insert.