Apple numbers User Manual

    Numbers Tools and Techniques 

 

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.

Discard changes.

Save changes.

Text field 
View or edit a formula.

Cancel button
Discard changes.

Save changes.

Click to open the

Function Browser.