Automatic summation in Excel

With the changes in the Times, now the computer function is endless, we can use Office software to carry out a series of operations and work, it seems that Office software has become an essential software for every company, but also become one of the necessary skills of our work. Then we have to learn as soon as possible to use Office software to skillfully use Office software to work, speed up the task quickly, then how to sum in Excel, this is just a very simple step and method, sum calculation can be automated.

Workaround and steps:

One, the mouse drag calculation:

1. Drag the mouse to select the data you want to calculate.

2. Click the auto Sum icon in the menu bar.

3. Automatic calculation has been completed.

Second, the formula input:

1. Select the table for which you want to output the calculated results. Enter a formula in the title bar, in the form "=sum (D1:D4)"

2. Horizontal lattice calculation is also this method. Just enter the two-lattice block punctuation, separated by a colon in the middle, and the carriage return is OK.

is not evaluated in a sequence:

1. Select the table for which you want to output the calculated results. 　　Click the sum icon and press the CTRL key to select all the numbers you want to calculate with your mouse. 2. Select all the numbers that need to be calculated and then enter, and the numbers of different sequences are automatically calculated.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join