Apple Numbers '09 User Manual

Page 128

When you reference a cell in a multi-row or multi-column header, you’ll notice the
following behavior:

The name in the header cell closest to the cell referring to it is used. For example, if

a table has two header rows, and B1 contains “Dog” and B2 contains “Cat,” when you
save a formula that uses “Dog,” “Cat” is saved instead.
However, if “Cat” appears in another header cell in the spreadsheet, “Dog” is retained.

To learn how to insert cell references into a formula, see “Using the Keyboard and
Mouse to Create and Edit Formulas” on page 128. See “Distinguishing Absolute and
Relative Cell References” on page 129 to learn about absolute and relative forms of cell
references, which are important when you need to copy or move a formula.

Using the Keyboard and Mouse to Create and Edit Formulas

You can type cell references into a formula, or you can insert cell references using
mouse or keyboard shortcuts.

Here are ways to insert cell references:
To use a keyboard shortcut to enter a cell reference, place the insertion point in the

Formula Editor or formula bar and do one of the following:

To refer to a single cell, press Option and then use the arrow keys to select the cell.

To refer to a range of cells, press and hold Shift-Option after selecting the first cell in

the range until the last cell in the range is selected.
To refer to cells in another table on the same or a different sheet, select the table

by pressing Option-Command–Page Down to move downward through tables or
Option-Command–Page Up to move upward through tables. Then use one of the
two techniques above to select one or more cells in the table.
To specify absolute and relative attributes of a cell reference after inserting one,

click the inserted reference and press Command-K to cycle through the options.
See “Distinguishing Absolute and Relative Cell References” on page 129 for more
information.

To use the mouse to enter a cell reference, place the insertion point in the Formula

Editor or formula bar and do one of the following in the same table as the formula cell
or in a different table on the same or a different sheet:

To refer to a single cell, click the cell.

To refer to all the cells in a column or a row, click the reference tab for the column

or row.
To refer to a range of cells, click a cell in the range and drag up, down, left, or right

to select or resize the cell range.

128

Chapter 6

Using Formulas in Tables