There may be times when Excel is not appropriate, but you need a formula within your Word document. Word Tables can not only format data similar to Excel, but formulas may be added to Word Tables as well.
First, let me show this easy tip for creating tables in Word.
Type the “Plus Sign” (+) at the location you want the table to start.
Tab to the point you want the next column to start and type another “Plus Sign.”
Continue doing this to create the first row of the Table with as many columns as needed.
Your page may look like this:
+ + + +
As soon as you press the “Enter” key, Word creates a Table with columns placed exactly where you typed the “Plus Signs.” See images above.
To add more rows, simply place the cursor in the far right cell and continue pressing the “Tab” key to add rows.
NOTE: Remember that cells in a Word Table are labeled much like cells in Excel. The upper left most cell is consider cell A1. The second column, first row (the cell to the right of A1) is considered cell A2. Each row is labeled by the letters of the alphabet. Row 1 is considered row A. The columns are labeled by numbers. Column 1 is considered “1.” Column 2 is considered “2” and so forth. Therefore, the cell located in the second row and fourth column would be cell “B4.”
When formulas are needed in a Word Table, follow these steps.
Word 2003 (and earlier):
Place the cursor in the cell you wish to contain the formula.
Simply type the formula as you would in Excel.
For example, if column 3 needs a “Total,” type the following formula in cell B10.
Many variations of the formula will also work.
=SUM(ABOVE) will calculate all cells in the column above the formula.
=SUM(LEFT) will calculate all cells in the row to the left of the formula.
Use most any basic formula from Word to calculate cells in a Word Table.
With the new ribbon layout in Office 2007, you will notice the “Layout” tab opens when a Table has been created. It will be located to the right of all other Tabs.
Click on the “Layout” tab and select the “Formula” button in the “Data” area of the ribbon. This button is located to the far right by default.
In the “Formula” dialog window (see image above), type the formula in the “Formula” field. The same formulas discussed above will work in Word 2007.
If advanced formulas are necessary or you need assistance with formulas, click on the “Paste Function” drop down arrow and select the function you want.
Click on the “OK” button when you have finished.
Use these instructions for basic calculation needs and Excel may not be necessary for formulas that can easily be input into Word Tables.