Microsoft Office Tutorials and References

In Depth Information

**Tables: Copying Formulas**

Note:
The number format specified must correspond to the settings specified for the

Windows Regional settings. For example, if a comma is set as the decimal

separator in Windows, a comma must be used in the table number format.

Tip:
To learn more about acceptable values for number formatting, search "number picture field

switch" in Word's Help, as well as looking at the information on the Format function in the

VBA Help.

Tables: Copying Formulas

Wrd

This procedure copies formulas, while adjusting the row references.

Example file:

W015

Scenario:
Microsoft encourages its customers to use Excel

for anything that requires calculation, and to use Word for

text-oriented tasks. There are times when inserting an Excel

sheet into a Word document is not a workable solution.

Using Word for simple calculations in small tables presents no

great problems. However, if the same formula needs to be

used across many rows that references cells in those rows,

the task becomes frustrating. Unlike Excel, Word uses

absolute cell references that do not adapt automatically when

a formula is copied to a different row, which means virtually

every formula must be manually created.

This tool enables a formula to be copied to as many rows as

desired.

This tool picks up the formula in the currently selected cell, displays a dialog box

to confirm that this is the formula to be copied, and selects the parts of it that

should be changed. Select the cells to which the formula should be pasted and

click "Copy Formula". The Formula is copied to these cells with the appropriate

corresponding row references.

In the illustrated example, all instances of (A2 * C2) in the original formula

(top of dialog box) will be changed to (A3 * C3), (A4 * C4) and so on.