How to automatically calculate totals in excel tables

How to automatically calculate totals in excel tables: First, select cell C1 with the mouse; then enter "=a1 b1" in cell C1. After completing the input, press the Enter key on the keyboard to get the result.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to automatically calculate totals in excel tables:

1. First, select cell C1 with the mouse, and then enter "=a1 b1" in cell C1. The input is complete. Then press the Enter key on the keyboard to get the result.

2. Batch automatic summation method in Excel (add the data in a1 to a12 and the data in b1 to b12, and the results are arranged in order from c1 to c12 (middle) as shown in the figure below:

3. Use a single summation to add "a1 and b1, and the result is in c1", which is the single summation step above. ;

4. Move the mouse to the lower right corner of cell c1, but when the mouse changes to a black cross shape, click the left mouse button and hold it down, drag to Release the mouse after placing it in cell C12. From c1 to c12 is the result of the addition of a1~a12 and b1~b12.

Related learning recommendations: excel tutorial

The above is the detailed content of How to automatically calculate totals in excel tables. For more information, please follow other related articles on the PHP Chinese website!