How to update formulas in a Word document?

by Manshu on September 7, 2010

in Personal Technology

Last week I wrote a post about using formulas in Word, and reader Rajesh wrote to me telling me that the formulas don’t auto – update when you change the values. I hadn’t noticed this before, so I tried it and found that you have to manually update the formulas, and this doesn’t quite behave as it does in Excel.

The good news is that it isn’t  that hard to update a value, – you can just place your cursor on the cell with the formula, right click, and hit “Update Field” if you have just one formula.

If you have more than one, then it will be easier to select the entire document using Ctrl + A, and hitting F9.

That will update all values in the Word document.

Thanks to Rajesh for pointing that out!

I am posting the rest of the earlier post (which describes how to enter a formula) below in case you haven’t seen it. No need to read further if you have already seen that post.

I discovered a neat little feature in MS Word today which has been around for quite some time now, and can come quite handy if you have to perform calculations within a Word document, or create a template with calculations that others will use later on.

You can perform calculations in a MS Word table much in the same way you perform them in MS Excel. Say you have a table with Regions, and Sales like the one below.

image

If you want to find average sales then place your cursor on the cell that you want to show the number at – click Layout –> Formula, and then type =AVERAGE(ABOVE), and hit enter. Word will calculate the average for you, and show the number on the cell.

You can even reference the cells like B2, B3, B4 etc., and then perform more complex calculations too.

Here is an example: Say you have tele-densities from a few states, and want to see the difference between the maximum and minimum.

You can write a formula by referencing the cells like you do in Excel, and calculate the result. Here is how that would look like:

image

This works in MS Word 2007 and 2010, and can come quite handy if you have to do calculations for a report, or create a template or some other stuff that needs some light calculations.

Views: 10965


Get free daily updates in your email:






{ 2 comments… read them below or add one }

Shane February 11, 2011 at 6:59 am

Hi,

Good post – I’m not fluent in Word but just need to work out how to do the updates of fomulas.. Good read.

Thanks

Shane

Reply

Manshu February 11, 2011 at 6:04 pm

Glad you found it useful Shane.

Reply

Leave a Comment

Previous post:

Next post: