Excel is great for creating complex spreadsheets and embedding into Word. But, if you need to perform a few quick calculations in a table, you can use Word’s formula feature. This allows you to work directly within your table without having to involve the use of Excel. Below are the step-by-step instructions for working with formulas in Word tables. Information: The same steps apply whether you are using Word 2016 for Mac or Windows.
Inserting Formulas in a Table
- Create your table with all the necessary data. NOTE: A zero should be inserted in any empty cells that will be included in a formula to ensure you do not receive an error.
- Highlight the cell at the bottom of the column that you need to calculate.
- Click on the Layout Contextual tab.
- Click on Formula in the Data group.
- The Formula dialog box will open.
- Formula:– Enter the appropriate formula. The default =SUM(ABOVE) is automatically selected, but you can use the Paste function: to choose from the various functions available. NOTE: In addition to choosing ABOVE, BELOW, LEFT or RIGHT to work with all cells in the specified direction, you can reference individual cells and ranges just like you to in Excel.
- Number Format: — Select the appropriate formatting.
- Click OK to calculate the cell value and close the Formula dialog box.
Updating Formula Results
Formulas are automatically calculated when they are inserted and when the document is opened. The formula can also be manually updated by either –
- Selecting the table containing the results to be updated and then pressing F9.
To learn more about Office applications, please check out my courses at vlbteched.teachable.com.