Microsoft Office Tutorials and References

In Depth Information

**Working with Tables**

Chapter 5

Working with Columns and Tables

Word contains a number of predefined

calculations, called functions, that you can plug into your

formula fields. For example, if you simply want to

add adjacent cells, use the SUM function, such as

=SUM(ABOVE) or =SUM(LEFT). The ABOVE

function tells Word to add all the non-blank cells

directly above the answer cell. The LEFT function tells

Word to add all the non-blank cells directly to the

left of the answer cell. To use a function, choose

Table Tools>Layout>Data>Formula. You can either

accept the suggestion provided by Word, or click

the Paste Function drop-down menu and choose a

different function (see Figure 5-23).

Figure 5-22

Creating a calculation.

4.
Optionally, choose an option from the

Number Format drop-down menu. This

option determines the appearance of your

answer such as whether to include a dollar

sign, a percent symbol, or two decimal points.

Tip

Word cannot use a function to total the

entire column or row if your column or

row contains blank cells or cells with text

instead of values.

5.
Click OK. Word calculates the formula and

displays the results.

If you later make a change to any of the table cells

referenced in the formula, Word doesnâ€™t

automatically update the formula answer. Right-click over

the current answer and choose Update Field.

View the Formula

If you want to see the actual formula instead

of the result, right-click over the answer and

choose Toggle Field Codes. To view the

answer again, repeat the action.

Figure 5-23

Using calculation functions.