2012

To insert a Formula field in a table cell
1 Click inside the table cell.
2 On the Table toolbar, click Insert Field.
3 In the Field dialog box, Field Category list, select Objects.
4 In Field Names, select Formula.
5 To enter a formula, do one of the following:
■ Click Average, Sum, or Count. The Field dialog box closes temporarily.
To specify a range, click inside the first and the last cell. The result is
appended to the formula.
■ Click Cell. The Field dialog box closes temporarily. Select a cell in a
table in the drawing. The cell address is appended to the formula.
6 (Optional) Select a format and a decimal separator.
7 Click OK.
8 To save your changes and exit the editor, click in the drawing outside
the editor.
The cell displays the result of the calculation.
To automatically fill cells with incremented data
1 Double-click inside a table cell.
2 Enter a numeric value; for example, 1 or 01/01/2000.
3 Press the down arrow and enter the next desired numeric value.
4 On the Text Formatting toolbar, click OK.
To change the format of the cell data, right-click the cell. Select Data
Format.
5 Select the cell or cells from which you want to increment data from.
6 Click the grip in the lower right corner of the cell or cells.
To change AutoFill options, right-click the AutoFill grip in the bottom
right-hand corner of the selected cell range and select an AutoFill option.
7 Drag the grip through the cells you would like to automatically increment.
A preview of the value for each cell will display to the right of the selected
grip.
Use Formulas in Table Cells | 1521