Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Repeat formula down a column in a Word 2003 table
I have a table in Word 2003, with 100 rows and 10 columns.
Each row contains cells for gross income and for various expenses then the net amount. This formula is from the third row. It is placed in the "i" (9th) column to calculate the net amount of income and expense item: {=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"} Then I put it in the fourth row (same column) and each of the 3's are changed to 4's., and so fourth on down the column. Problem is this is an extremely slow and tedious process. I know there is a way to do it automatically. I have done it in the past ..., years ago, but I can't remember how, and I can not find it in any help file or any of the online helps. Please point me in the right direction to repeat the formula (updated for each row) in all the rows of the table. -- Thanks, Ray |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error messages when using table formula after moving column tot's | Tables | |||
Word 2003 Table Formula Number format displays errors. | Microsoft Word Help | |||
Word 2003 Table cell formula | Tables | |||
Word 2003 Table Header Row won't repeat. | Tables | |||
Word 2003 Table Header Row won't repeat. | Tables |