Three data calculation methods in Word table

I. Toolbar method,

1. Right-click the blank area in the toolbar and select "table and border" in the pop-up menu.

2. Move the cursor to the result output cell, and then click the find button to add the result immediately.

3. Although this method is fast, it can only sum and cannot perform other function operations. By default, the formula {= SUM (LEFT)} is used to calculate the SUM of all cells on the LEFT of the cell where the cursor is located. If the SUM of all cells on the right of the cell where the cursor is located is calculated, you can change the formula to {= SUM (RIGHT )}

4. If you click the find button for cells other than the first row, the default formula for WORD is {= SUM (ABOVE )}

2. Directly enter the domain code,

1. Move the cursor to the cell in the calculation result and press CTRL + F9 to insert the field identifier {}. Note that this curly braces cannot be entered directly on the keyboard.

2. Enter "= function name (cell name and symbol)" in curly brackets )"

3. Right-click the field you just entered and select "switch domain code" to display the result calculated by the formula. The shortcut key is SHIFT + f9"

4. The advantage of this method is that it is flexible, but you need to be proficient in using the domain.

III. Table-formula

1. Move the cursor to the cell of the calculation result, and click "formula" under the "table" menu"

2. You can enter or modify the formula in the formula text box. The simplest method is to directly select the function you need by pasting the function.

3. You can customize the display format of numbers in the "number format". This excel file is actually similar. If 0.00 is selected, the calculation result retains the last two decimal places.

4. You can test some common sum product functions. In addition, you can clearly understand the meaning of left above.

Notes

1. When the formula encounters a blank cell, when both rows and columns have data, WORD preferentially calculates the column results.

If the cells above the cells to be calculated are not blank, the results are calculated. The calculation result ends with the first blank cell.

2. The naming rules of cells in word are the same as those in excel. As shown in the figure, name the column number before and the row number after.

Therefore, I can directly reference the cell name during computation.

3. When the cell content involved in the calculation changes, you can scan F9 to update the field.

4. Of course, sometimes we also want to lock the domain. After selecting the domain, CTRL + F11 will be locked, and CTRL + SHIFT + F11 will be unlocked. If you want to lock the domain forever, you can simply CTRL + SHIFT + F9.

5. The calculation method for the entire row is as follows: 2: 2 indicates the second row, and a: a indicates the first column, which is similar to EXCEL.

{= SUM ()} automatically calculates the content of all cells. Of course, if a blank cell is displayed, word is automatically calculated as 0.
6. Bookmarks can also be used for data reference calculation, not only for table computing, but also for documents. I will explain this method in detail later.

7. For how to completely update the domain, first select "update domain" in the print option, and then print the document to directly update the domain. Of course, it would be too wasteful to print the domain. You can use a virtual printer.