Much of the time, people use Excel to sum columns and rows of data. In fact it occurs so frequently that Excel has included a feature called AutoSum that automatically performs a selected function, like SUM, on a selected column or row of uninterrupted (no blank) cells. This saves you time in creating basic formulas. In this post, we will discuss how to use the AutoSum feature in Excel.
1. Select the cell that is located the end of the column or row that you want to add, and then click the “AutoSum” button in the “Function Library” group on the “Formulas” tab in the Ribbon. Excel will select a range of adjacent cells for you. If Excel choose the wrong range of cells, just use your mouse to click and drag over the correct range of cells to use in the formula.
2. Click the “AutoSum” button again or press the “Enter” key on your keyboard to accept the formula.
3. Another way to use this tool is to click and drag over the cells in the columns or rows which you want to add, leaving a blank cell at the end of the columns or rows where you want the answer to appear.Then just click the “AutoSum” button once to add the columns and rows and display the answers in the blank cell or cells that you selected.
4. You can also click the drop-down below the “AutoSum” button to select a different function to perform. If the function you want to use is not shown, you can select the “More Functions…” command from the button’s drop-down menu to open the “Insert Function” dialog box where you can select from all of Excel’s available functions.