Formula tools – Apple Numbers '08 User Manual

Page 26

Advertising
background image

26

Chapter 1

Numbers Tools and Techniques

Here are ways to open an Inspector window:

m

Click Inspector in the toolbar.

m

Choose View > Show Inspector.

m

To open another Inspector window, press the Option key while clicking an Inspector
button.

After an Inspector window is open, click one of the buttons at the top to display a
different inspector. Clicking the second button from the left, for example, displays the
Sheet Inspector.

Formula Tools

You add a formula to a table cell when you want to display a value in the cell that’s
derived using a calculation. Numbers has several tools for working with formulas in
table cells:
 The Formula Editor lets you create and modify formulas. Open the Formula Editor by

selecting a table cell and typing the equal sign (=). You can also open it by choosing
Formula Editor from the Function pop-up menu in the toolbar.

Learn more about this editor in “Using the Formula Editor” on page 88.

 The Formula Bar, always visible beneath the Format Bar, can also be used to create

and modify formulas.

Instructions for adding and editing formulas using this tool are in “Using the Formula
Bar” on page 90.

Move the Formula Editor

by grabbing here

and dragging.

Text field
View or edit a formula.

Cancel button

Discard changes.

Accept button

Save changes.

Text field
View or edit a formula.

Cancel button
Discard changes.

Accept button

Save changes.

Click to open the

Function Browser.

Advertising