Finding and Replacing Formula Elements
Using the Find & Replace window, you can search through all of a spreadsheet’s
formulas to find and optionally change elements.
Here are ways to open the Find & Replace window:
Choose Edit > Find > Show Search, and then click Find & Replace.
m
132
Chapter 6
Using Formulas in Tables
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.
134
This chapter describes how to create and format attractive
charts from the data in your tables.
Numbers provides tools for creating your own visually appealing charts to present
some or all of the data in one or more tables. By default, the appearance of charts is
coordinated with the theme you’re using, but you can adjust colors, textures, shadows,
labels, and more to create the look you want or to emphasize various chart elements.
About Charts
Use a chart when you want to visually represent trends or relationships that may be
more difficult to see when data is presented in a table. In Numbers you can choose
from a variety of 2D or 3D chart types to present your data, including pie charts, line
charts, bar charts, column charts, and area charts, depending on which works best to
make the point with your data, or use a mixed chart to overlay two chart types within
the same figure. You can also graph your data in a two-dimensional scatter chart, using
linear or logarithmic scales.
Numbers includes the following types of charts:
Kind of chart
Icon
Column
Stacked column
Bar
7