2012

5 To save your changes and exit the editor, click in the drawing outside
the editor.
To manually enter a formula in a table cell
1 Double-click inside a table cell.
The In-place Text Editor opens.
2 Enter a formula (a function or an arithmetic expression), as in the
following examples:
■ =sum(a1:a25,b1). Sums the values in the first 25 rows of column A
and the first row in column B.
■ =average(a100:d100). Calculates the average of the values in the first
4 columns in row 100.
■ =count(a1:m500). Displays the total number of cells in column A
through column M in rows 1 through 100.
■ =(a6+d6)/e1. Adds the values in A6 and D6 and divides the total by
the value in E1.
Use a colon to define a range of cells and a comma for individual cells.
A formula must start with an equal sign (=) and can contain any of
the following signs: plus (+), minus (-), times (*), divided by (/),
exponent (^), and parentheses ().
3 To save your changes and exit the editor, click in the drawing outside
the editor.
The cell displays the result of the calculation.
To change the background color of column letters and row numbers for
tables
1 Click a grid line to select a table.
2 Right-click. Click Table Indicator Color.
3 In the Select Color dialog box, select a color.
4 Click OK.
The text color, size, and style and the line color are controlled by the
settings for column heads in the current table style.
1520 | Chapter 30 Tables