Microsoft Excel

Tech Help

How do I use the AutoSum button?

You can use the AutoSum button to quickly create a formula to find the total of set of numbers in a column or row.  It is much easier than trying to create your own formula.

To Begin:

Click in the cell where you want your answer to be, generally right at the bottom of a column or end of a row of numbers.

Click the AutoSum button.

The range of cells above or beside is outlined with marching ants.

If these are the right cells and the Sum formula is correct, press the Enter key to complete the calculation. 

 
If incorrect cells are outlined, simply highlight the cells that you wanted to include in the formula and then press the Enter key.
 
Curriculum
Teacher Projects
Tech. Help
Communications
Prof. Development

© 2002 Tammy Rodolico, North Shore Technical High School, 30 Log Bridge Rd., Middleton, MA 01949 - Email Webmaster