Microsoft | Sofware | How to Make a Number of Rows and Columns In Table Word 2013 | Making Guide Number of Rows and Columns In Table Word 2013 If you are working in Word, and you need to total the values in a table, you can do so without having to enter the data into Excel and then copy and paste into Word. Words can perform simple calculations such as sum, multiply, and an average.
Note: When you add a new row or column values into a table in Word, the formula will not be automatically updated. To update the formula, right-click on the formula and selecting Update field from the pop-up menu.
To insert a formula into a cell in a table, place the cursor in the cell and click the Layout tab under Table Tools.
Click on the Formula Data Layout tab.
In this example, we will multiply the unit by Unit Cost Total column and then total. To do this, we enter the following in the Formula edit box in the Formula dialog box to multiply the two numbers to the left of the current cell.
= PRODUCT (LEFT)
Make a selection from the drop-down list to specify the number format format format for the result of the formula.
Click OK to accept the settings and enter the formula into the cell.
Displays the results of the formula in the cell.
Note: If you right click on a cell that contains the formula and select Toggle Field Codes from the pop-up menu, featuring actual formula in the cell, as shown in the first picture at the beginning of this article. Right-click again and select Toggle Field Codes again to display the results.
We follow the same steps to reproduce the unit and Unit Cost in every other row.
Now, make sure there is an extra row at the bottom of the table so that we can be the total cost. Place the cursor in a blank cell at the bottom of the column total. Click on the Formula Data Layout tab to access the Formula dialog box. Enter the following formula in the formula edit box (probably a standard formula with the SUM formula above as an argument).
= SUM (ABOVE)
Select the appropriate number format and click OK.
Total column shows the number of cells.
(iklan)
0 komentar:
Post a Comment