Current location - Training Enrollment Network - Mathematics courses - How to sum the data of each column in excel table at the same time?
How to sum the data of each column in excel table at the same time?
1. Open excel and enter the required data.

2. Enter "=" in cell C 1.

3. Then enter the formula: A 1+B 1, and the final formula is "=A 1+B 1".

4. Click Enter to generate the calculation result.

5. Move the mouse cursor to the lower right corner of the cell.

6. After the cursor appears cross, double-click the mouse and the formula will be filled in automatically.