Lets say I have a table with 4 columns - desc, price, qty, total

In the first row I put a formula in the 4th column to multiply the price and
the qty - so far so good.

Now how do I copy that formula to every row?

If I cut and paste then it retains the reference to price and qty in the
first row instead of the same row as the formula (as excel would do). This
means I have to manually enter a formula for every single row - is there any
way around this?

Word does not do intelligent copying. Use Excel and link the table into
Word.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




anon4186 wrote:
Lets say I have a table with 4 columns - desc, price, qty, total

In the first row I put a formula in the 4th column to multiply the
price and the qty - so far so good.

Now how do I copy that formula to every row?

If I cut and paste then it retains the reference to price and qty in
the first row instead of the same row as the formula (as excel would
do). This means I have to manually enter a formula for every single
row - is there any way around this?

See the "Use Relative Cell References in Word table formulas" item under the
Nifty Numbering section of fellow MVP, Cindy Meister's website at
http://homepage.swissonline.ch/cindy...r/MiscFram.htm

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"anon4186" wrote in message
news
Lets say I have a table with 4 columns - desc, price, qty, total

In the first row I put a formula in the 4th column to multiply the price
and
the qty - so far so good.

Now how do I copy that formula to every row?

If I cut and paste then it retains the reference to price and qty in the
first row instead of the same row as the formula (as excel would do).
This
means I have to manually enter a formula for every single row - is there
any
way around this?