Is there a way to copy formulas within a table in Word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VLackey513 - 29 Mar 2008 16:57 GMT

I am trying to find a way to copy formulas in a Word table, like is done in
Excel, so as not to have to enter the formaula for each row. Does anyone know
how to do this?

Reply to this Message

Fredrik E. Nilsen - 29 Mar 2008 17:05 GMT

>I am trying to find a way to copy formulas in a Word table, like is done in
>Excel, so as not to have to enter the formaula for each row. Does anyone know
>how to do this?

You can copy the formula and paste it, just like you do with regular
text. You have to update the formula fields to reflect the new values.
Press Ctrl+A and then F9 to update all fields.

Signature

Fredrik E. Nilsen
http://fenilsen.wordpress.com

Reply to this Message

Beth Melton - 29 Mar 2008 20:22 GMT

Unfortunately, no. Word doesn't support relative cell referencing like
Excel. As Fredrik noted, you can copy/paste them but you need to manually
update the pasted formula to reflect the correct column/row.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

>I am trying to find a way to copy formulas in a Word table, like is done in
> Excel, so as not to have to enter the formaula for each row. Does anyone
> know
> how to do this?

Reply to this Message

Doug Robbins - Word MVP - 29 Mar 2008 22:25 GMT

To see how to do this and a wide range of other calculations in Word, check
out fellow MVP, Macropod's Word Field Maths 'tutorial', at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to find a way to copy formulas in a Word table, like is done in
> Excel, so as not to have to enter the formaula for each row. Does anyone
> know
> how to do this?

Reply to this Message