copying formulas

A

anon4186

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?
 
G

Graham Mayor

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
D

Doug Robbins

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/cindymeister/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
 
Top