Word 2010: Insert Tables & Formulas

Word 2010 provides a great feature of using tables along with document content to complement and summarize it in a better way, but sometimes in tables we also need to write the formula for evaluation of values. Although it does not support a huge range of formulas, we can use basic formulas that will be sufficient for most users. This post elaborates how to create and apply new design over the table and how to get required results through formula with simple illustrations.

To begin, launch Word 2010 document in which you want to calculate values using formula. For instance, we have included a document, containing table. In order to insert a table, navigate to Insert tab and click Table. Now select the number of rows and columns, as shown in the figure below.

insert table

Once selected, start populating the cells with the data.

cell

If you want to give it a better look, select the table, and two new tabs will appear on the ribbon Design and Layout. You can change the design by navigating to the Design tab and select the suitable style for the table from group Table Styles. In Design tab, it includes a number of table styles. Clicking the style will quickly apply it over your table. It also allows you to choose custom table colors and shades from Shading drop down menu, present alongside the table style gallery.

design tab 1

Click on the style you want to apply it over the table.

table style


From Layout tab, you can customize the generic layout of the table, from the Cell Size group, select the size of the cell, from Merge, you can use the suitable option to merge cells, from Rows & Columns, you can insert a new row or column into the table. From Table group you can insert gridlines, and view properties of the table.

layout tab 1

Now we need to calculate the total Price of the products, click the cell Total in the table, and click Formula from Layout tab, as shown in the screenshot below.

formula

Upon click, Formula dialog will appear. Under Formula, =SUM(ABOVE) is automatically inserted, this can evaluate the sum of all the above values. From Number Format drop down list select one which includes dollar sign, as we are dealing with currency values, click OK to continue.

formula tab

Upon click, it will show the sum of values.

result

You can also check out previously reviewed guides on How to Add dictionary in Word 2010 & Indexing in Word 2010.

Advertisement
  • Mary Ann

    This is right on! Thanks…

  • Arleen

    This was SOOO much help!! Thank you kindly!!

  • Sonnyck

    A problem I am having is that I creat a simple 1 line table of 5 rows, but while typing the content Word just adds a 6th row that even goes out of my page. What is going on?

  • Cathy

    That is NOT auto sum. You have to redo it every time you add an entry. Office took out the auto sum feature.

    • http://www.facebook.com/l.coollee.3 L L Cool Lee

      Although it won’t automatically re-add the total if you change a number, but if you put your cursor on the total, and right-mouse click and hit “update field”…it will total it again.

      • HF

        If you select all (Ctrl + A) and then press F9, it will update all fields at once

  • Paul

    You have to redo it every time you update a value? This is going to cause a lot of problems for a lot of people who are expecting to change the numbers and the total automatically updates.

  • Karen

    thanks a bunch! microsoft online support did not help at all.

  • Sonia

    Hi Yep this helped with the basic.
    I’m just enquiring what formula’s would work when making a purchase order.  So I want to multiply the quantify of products with unit price equalling total Price.
     
    If i can get assistance with this one then I can play with the formula to add and subtract Sub Total, tax and delivery fee and equal total.
     

  • Sonia

    Hi Yep this helped with the basic.
    I’m just enquiring what formula’s would work when making a purchase order.  So I want to multiply the quantify of products with unit price equalling total Price.
     
    If i can get assistance with this one then I can play with the formula to add and subtract Sub Total, tax and delivery fee and equal total.
     

  • Gwhite

    i have a list of numbers in my table.  i would like the numbers to line up.  i am using parenthesis () to denote negative numbers.  although i have it right aligned, the closing parentesis moves the number over a character and then the numbers aren’t lined up.  any help? 

    • Guest

      Have you tried creating a decimal tab?

  • Ken

    Great info.  Can nested formulas be used in Word 2010 tables to conditionally set the content of a table cell?

  • Frank

    Great – but how do I give it a title, that I can then reference in (for example) a list of tables

  • Cindywalker98

    In Word 2010 what is a table within a table called?

  • linusvp

    Just a note to those that just want to simply click on a button and auto sum anything in table, simply go to File >  Options > Customize Ribbon.

    Under the ‘Choose Commands From’ dropdown box, change it from ‘Popular Commands’ to ‘All Commands’.

    Scroll down until you see the command ‘Sum’ and select it.

    On the right side, you can add a new group where ever you want the Sum button to go.  I just make a Sum entry in my main tab section. 

    After making your custom group on the right, simply add the ‘Sum’ command from the left to the one you just made on the right. 

    You are all set, a simple sum button right in your ribbon. :)

    • lesleyleevey

      This works – cheers it’s made it so much simpler

  • Jlwood66

    Useful article!  But I need an autosum — that recalculates the sum if one of the values changes.  Not very useful without that feature.

  • Jongc

    I need to subtract and can not find the difference anywhere.

  • Oldman96

    You did what my college prfoessor and college book couldnt tell me to do in an hour, in just a few seconds. Thank im tired of this world overcomplicating shit

  • Cbugner

    How do you format each cell to show decimal and or $ sign.  Format painter won’t even copy the formula format indicated in the final figure. (Sum – format)

    • Aveltman

       I have the same question and have just spent 30+ minutes looking all over the internet! How do I see the answers to the questions in this forum?

  • Ezzatabdellah

    so easy , so good ….. thanks

  • MerlA

    In word Im trying to get this chart to do averages and keep getting Syntex errors.
    I do =Average(B4:C4:D4)

    COLEMAN
    DEVELOPMENT CORPORATION

    New Employee Orientation

    Name

    Quiz 1

    Quiz 2

    Quiz 3

    Average

    Mary Castillo

    88

    74

    90

    Patrick Donahue

    92

    86

    84

    Angela Herron

    78

    66

    72

    Jason Kepler

    84

    76

    80

    Teresa Miroshi

    76

    82

    78

    Thomas Newton

    96

    98

    94

    Desiree Pollock

    84

    68

    80

  • Kim

    I need to enter the formula for “Qty x Unit Price” for a line total on an invoice. I’ve go the sum on the line but cannot get it to calculate the qty times the unit price

  • Toni Sospirato

    How do you show the codes that were used? In Excel, you use Control toggle, what is it in Word?

  • http://www.facebook.com/profile.php?id=1044744177 Cheryl Lawson

    I need to complete my mail merge – can’t get the formula to work that places the dollar sign, commas & periods in the number entries. Help?????

  • ElleBelle

    So . . . just confirming. Format Painter can’t quickly fill table cell? Agggghhhhh!

  • KLeeV

    Can I reference another cell in a functions, like in Excel. I want to enter a date then have each successive date change. Is this possible? In Excel I would enter =A2+1. A2 represents the cell that I would enter a date.

  • trol

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

    trollllllllllllllllllllllllllllllllll

  • hi

    this be gooood

  • Lemon

    tbh u 4ll 5uck

  • Arsehole

    Suckz me hairy cock u ugly bastards!

  • Cecilia

    Unfortunately, the above did not work w hen I tried to add my column of figures. I got weird messages like “syntax error,” zero values aren’t legal, and other baffling messages. The best that came up was the sum of 2 in the cell immediately above. I also tried to use the autosum button, and that gave me “formula failed.” I tried selecting all the cells which I wanted to add, but no luck there, either. I have previously used the autosum as well as formulas in other documents, and everything worked just fine. I am really stymied and have wasted a lot of time on this when I just should have added the numbers in my head! But it is work hours, and I didn’t want to make any mistakes!

  • pawan sahu

    thank you

  • Phil

    Im trying to add a formula to a table that is in a form. In Column A there is a price list which does not change and can not be edited. In Column B I have inserted Control boxes to type in when the document is protected as a form. In column C, I want to times A * B, but It doesn’t read the control box.
    Is there a way around this?

    thanks

  • momin

    I need to subtract and can not find the difference anywhere.