The inspector window, Formula tools, 20 the inspector window 20 formula tools – Apple Numbers '09 User Manual
Page 20

The Inspector Window
Most elements of your spreadsheet can be formatted using the Numbers inspectors.
Each inspector focuses on a different aspect of formatting. For example, the Cells
inspector lets you format cells and cell values. Hold your pointer over buttons and
other controls in the inspector panes to see a description of what the controls do.
The buttons at the top of the
inspector window open the
ten inspectors: Document,
Sheet, Table, Cells, Chart, Text,
Graphic, Metrics, Hyperlink,
and QuickTime.
Opening multiple inspector windows can make it easier to work on your spreadsheet.
For example, you can open both the Graphic inspector and the Cells inspector to have
access to all the image- and cell-formatting options.
After an inspector window is open, click any of the buttons at the top to display a
different inspector. Clicking the second button from the left, for example, displays the
Sheet inspector.
Here are ways to open an inspector window:
Click Inspector in the toolbar.
m
Choose View > Show Inspector.
m
To open another Inspector window, choose View > New Inspector.
m
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.
Cancel button
Discard changes.
Accept button
Save changes.
Text field
View or edit a formula.
Formula Editor
Move by grabbing
here and dragging.
20
Chapter 1
Numbers Tools and Techniques