Home  >  Article  >  Topics  >  How to automatically sum vertical columns in excel

How to automatically sum vertical columns in excel

coldplay.xixi
coldplay.xixiOriginal
2021-01-06 15:42:32191036browse

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.

How to automatically sum vertical columns in excel

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.

How to automatically sum vertical columns in excel

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.

How to automatically sum vertical columns in excel

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.

How to automatically sum vertical columns in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn