Owner manual
Chapter 1 Using Formulas in Tables 31
Viewing All Formulas in a Spreadsheet
In Numbers, to view a list of all the formulas in a spreadsheet, choose View > Show
Formula List or click on the formula list button in the toolbar.
Location: Identies 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 nd formulas that contain a particular element, type the element in the search eld m
and press Return.