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
This procedure copies formulas, while adjusting the row references.
Example file:
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
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.
Search JabSto ::

Custom Search