2012

Copy a Formula
When you copy a formula to another cell in the table, the range changes to
reflect the new location. For example, if the formula in A10 sums A1 through
A9, when you copy it to B10, the range of cells changes so that it sums B1
through B9.
If you don't want a cell address to change when you copy and paste the
formula, add a dollar sign ($) to the column or row part of the address. For
example, if you enter $A10, the column stays the same and the row changes.
If you enter $A$10, both column and row stay the same.
Insert Data Automatically
You can automatically increment data in adjacent cells within a table by using
the AutoFill grip. For example, a table with a date column can have the dates
automatically entered by entering the first necessary date and dragging the
AutoFill grip.
Numbers will fill automatically by increments of 1 if one cell is selected and
dragged. Similarly, dates will resolve by increments of one day if only one cell
is selected. If two cells are manually filled with dates one week apart, the
remaining cells are incremented by one week.
See also:
■ Use Fields in Text on page 1458
To add a formula to table cells
1 Select the table cell where you want to place the formula by clicking
inside it. The Table toolbar is displayed.
2 On the Table toolbar, click one of the following:
■ Insert Formula ➤ Average
■ Insert Formula ➤ Sum
■ Insert Formula ➤ Count
■ Insert Formula ➤ Cell
3 Follow the prompts.
4 Edit the formula, if necessary.
Use Formulas in Table Cells | 1519