- Select the cell in question. In this case, select the empty cell to the far right of the Nichols row.
- Choose Formula from the Table menu.
- In the resulting dialog box, Word will display the default formula, which references the values above.
- Change ABOVE to LEFT, and click OK.
You can also use the Formula command when you want to specify individual values. That's because Word assigns an identifying value to each cell in the table. Every cell has two identifiers, a row identifier (a number) and a column identifier (a letter). For example, the first cell in the top-left corner is A1. The next cell to the right is B1. The cell just below A1 is A2, and so on. When evaluating individual values, separate them using a comma as follows: =SUM(B2, C4,…) In addition, you can substitute the default formula with a variety of functions. Simply delete all of the default formula, except for the equal sign, and then choose a function from the Paste Function drop-down list. This flexible but somewhat limited feature has a lot to offer. However, you must remember to recalculate the file each time you change a value in the table. Word will not update formulas automatically. Simply select the entire table and press [F9] and Word will reevaluate all the formulas in the table. Or highlight an individual cell and press [F9] to recalculate a single formula.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.