Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Ray Ray is offline
external usenet poster
 
Posts: 14
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
error messages when using table formula after moving column tot's hunguponword Tables 3 November 26th 06 03:27 AM
Word 2003 Table Formula Number format displays errors. Mark Microsoft Word Help 2 April 6th 06 06:51 AM
Word 2003 Table cell formula Terry Tables 1 June 5th 05 08:59 AM
Word 2003 Table Header Row won't repeat. LindaB Tables 1 March 14th 05 02:39 PM
Word 2003 Table Header Row won't repeat. Linda B Tables 1 November 29th 04 01:28 PM


All times are GMT +1. The time now is 10:33 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"