Excel 2010 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

You can use the AutoSum button in Excel 2010 to quickly sum a row or a column of values in an Excel worksheet. The AutoSum button is located in the Editing group of the Home tab. When you click this button, Excel inserts the built-in SUM function into the active cell and simultaneously selects what the program thinks is the most likely range of numbers that you want added together.

Click a cell below (or to the right of) the values you want to sum.

This tells Excel which values you want to sum.

Click the AutoSum button in the Editing group on the Home tab.

Click the AutoSum button in the Editing group on the Home tab.

Excel inserts an equal sign followed by the SUM function and a suggested range of values to sum, displayed in a marquee.

If the suggested range is incorrect, drag the cell cursor across the cells to select the correct range.

If the suggested range is incorrect, drag the cell cursor across the cells to select the correct range.

The marquee adjusts to surround the range of cells you select.

Press Enter or click the Enter button on the Formula bar.

Excel enters the SUM formula in the cell.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: