Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
external usenet poster
 
Posts: 50
Default How can formula output be updated when rows &/or columns are added

How can the results of formulas in WORD tables be updated, when not only the
input data referenced by the formulas changes, but rows &/or columns are
added or subtracted to the table containing the formula(s), thus changing the
cell locations referenced by the formula(s)?

I assume (fingers crossed) there is a way to do this?

Replies appreciated.

Example: Formula in cell G4 . . . =E4*F4. Then a row is added above, so
that G4 becomes G5. How, other than actually editing the formula each time
this happens, can the formula be made to continue working properly?
 
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
Mailmerge using columns instead of rows tamee Mailmerge 2 March 28th 07 02:07 AM
Hiding Rows and Columns ron10bees Tables 1 September 23rd 06 10:17 PM
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? CalMac Captain Tables 1 May 19th 06 03:27 PM
convert columns into rows GreenEyedMedusa Tables 3 November 28th 05 07:50 PM
Mailmerge wont see Added Excel Data source Columns Thatdampwood Mailmerge 3 December 2nd 04 10:56 PM


All times are GMT +1. The time now is 10:00 PM.

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"