Using Autosum in Excel

Using Autosum in Excel

This is really part 2 of the using formulas in excel lesson but it deserves its own lesson. We could do a million tutorials on the functions in excel as there are many. If I could chose one formula to look at, it would be this one. This will be a very short and sweet tutorial so pay very close attention. Autosum in Excel will let you add columns or rows with just one click. That's right! One Click (and a click and drag - but forget that!). You will see what I mean very soon.

Using autosum in Excel will save you from typing in C3+C4+C5+C6+....C5000

How to Use Autosum in Excel:
Image Tutorial

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on first cell A1 and type in a number.
3. Click on second cell A2 and type in a number.
4. Click on next cell A3 and type in a number.
5. Click on next cell A4 and type in a number.
6. Click on cell A1 and hold the left mouse button.
7. Drag the mouse down to cell A5 (until A1 through A5 are highlighted) then release the left mouse button.
8. Click on the symbol on the toolbar.
9. Your total should now be in the E1 cell.

You can also use this for rows. Easy and useful just the way I like it. Good job Microsoft on the Autosum Function in Excel.


If you had any problems completing this module or think some details need more explanation, please let us know. We also welcome any other feedback.
Send Feedback