A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 29th, 2008, 03:57 PM posted to microsoft.public.word.tables
VLackey513
external usenet poster
 
Posts: 4
Default Is there a way to copy formulas within a table in Word?

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?
  #2  
Old March 29th, 2008, 04:05 PM posted to microsoft.public.word.tables
Fredrik E. Nilsen
external usenet poster
 
Posts: 137
Default Is there a way to copy formulas within a table in Word?

On Sat, 29 Mar 2008 08:57:01 -0700, VLackey513
wrote:

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.

--
Fredrik E. Nilsen
http://fenilsen.wordpress.com
  #3  
Old March 29th, 2008, 07:22 PM posted to microsoft.public.word.tables
Beth Melton
external usenet poster
 
Posts: 2,566
Default Is there a way to copy formulas within a table in Word?

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

"VLackey513" wrote in message
...
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?



  #4  
Old March 29th, 2008, 09:25 PM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Is there a way to copy formulas within a table in Word?

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/show...?Number=365442


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

"VLackey513" wrote in message
...
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.