Excel like calculations in Word

Most of us are comfortable with Microsoft Word. Wouldn’t it be nice if we could perform Excel like calculations in Word?
This has many advantages including the ones mentioned here:

  • Tables in Word can be formatted in a variety of ways to make our documents look professional and beautiful
  • We don’t need to copy and paste an Excel worksheet

Word provides many equations and arithmetic formulas like sum for addition, product for multiplication, etc. Once we have our data in a table we can perform the relevant calculations as shown in the training video.
The cells in a table can be accessed using notations like A1, B1, C1, etc. In the description A1 the letter A represents the first column and ‘1’ represents the first row. Also you need to click on ‘Table’, then on ‘Formula…’ and in the formula pop-up window you can specify the formula and the number formatting. As mentioned before Word has many arithmetic functions available to the user which can be pasted quickly and easily to perform the specified calculation. Tip:: If you change some values in the cells of the table where you had accessed the cells using cell addresses you can select the result of the earlier calculation and press F9 to recalculate.

Further reading:
Add calculating rows and columns to a Word table

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.