How do rows or columns of an Excel worksheet automatically sum?

The use of Excel software features to automatically sum, can play a multiplier effect, this experience is used to describe how to use Excel worksheet row or column of the automatic summation, general can directly use the Automatic Sum toolbar options, and then there is the use of the insertion function sum can be done, You will not be able to leave this excel with the habit. The following small series for everyone to introduce the Excel worksheet row or column how to automatically sum method, hope to help everyone!

Open a worksheet, this is a virtual payroll, when the names of people and payroll are filled in after the last payroll, if one of the plus will be very time-consuming, now we dot the formula in the menu bar

Point out the toolbar under the Formula menu and find the automatic summation in the function library

When you click Automatic summation, the table formula for the summation appears.

The number of double clicks at the sum is out.

After the first line comes out, the following point live down drag, will be automatically summed in the format

The results are as follows, soon the payroll will be available, you can use the calculator to verify

or click the Insert function above to calculate the sum by the function, and the steps are the same.

The above is an Excel worksheet row or column how to automatically sum the method introduction, hope to be helpful to everybody!