copying formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anon4186 - 26 Feb 2005 20:59 GMT

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?

Reply to this Message

Graham Mayor - 27 Feb 2005 07:58 GMT

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

Signature

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

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

> Lets say I have a table with 4 columns - desc, price, qty, total
>
[quoted text clipped - 7 lines]
> do). This means I have to manually enter a formula for every single
> row - is there any way around this?

Reply to this Message

Doug Robbins - 27 Feb 2005 14:30 GMT

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

Signature

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

> Lets say I have a table with 4 columns - desc, price, qty, total
>
[quoted text clipped - 10 lines]
> any
> way around this?

Reply to this Message