Apple Numbers '09 - Manual (Page 132)

If you move a cell that a formula refers to, the cell reference in the formula is
automatically updated. For example, if a reference to A1 appears in a formula and you
move A1 to D95, the cell reference in the formula becomes D95.
Viewing All Formulas in a Spreadsheet
To view a list of all the formulas in a spreadsheet, choose View > Show Formula List or
click Formula List in the toolbar.
Location: Identifies the sheet and table in which the formula is located.
Results: Displays the current value computed by the formula.
Formula: Shows the formula.
Here are ways to use the formula list window:
To identify the cell containing a formula, click the formula. The table is shown above
m
the formula list window with the formula cell selected.
To edit the formula, double-click it.
m
To change the size of the formula list window, drag the selection handle in its upper m
right corner up or down.
To find formulas that contain a particular element, type the element in the search field
m
and press Return.
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