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

Page 20

Advertising
background image

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

Advertising