How to automatically sum vertical columns in excel

How to automatically sum vertical columns in excel: First create a blank table and enter the corresponding data; then enter [=SUM(B2:D2)] in cell E2 and confirm; finally, place the mouse on E2 In the lower right corner of the cell, drag down when the cross mark appears.

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

How to automatically sum vertical columns in excel:

1. Open excel, create a new blank table and enter the corresponding data.

2. First, we enter=SUM(B2:D2)in cell E2 and confirm again, so that the total of a student can be calculated. score.

You can also select cell E2 first, then select the formula menu to find the automatic sum menu, and then select the odd number cell you want to sum.

3. Next, we will automatically calculate the total scores of other students. Place the mouse in the lower right corner of cell E2. When a cross mark appears, press Ctrl while holding it down. , hold down the left mouse button and drag downward, then release the keyboard and mouse.

Related learning recommendations:excel tutorial

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