How to Use the AutoSum Feature in Microsoft Excel 2013
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.
- Create a Form from an Existing Document in Acro...
- The CREATE TABLE Statement in SQL: Overview ...
- Keyboard Shortcuts from Windows to Macs: Overvi...
- Create a Contact Group (Distribution List) in O...
- Access 2010
- Access 2013
- CPE Information for CPAs
- Crystal Reports
- Excel 2010
- Excel 2013
- Microsoft Excel Training for Lawyers
- Microsoft Office Online
- Microsoft Outlook Training for Lawyers
- Microsoft Word Training for Lawyers
- Office 2010
- Office 2013
- Office 365
- OneNote 2013
- Outlook 2010
- Outlook 2013
- Photoshop Elements
- PowerPoint 2010
- PowerPoint 2013
- Project 2013
- Publisher 2010
- Publisher 2013
- QuickBooks Training for Lawyers
- Small Business Accounting
- What's New at TeachUcomp?
- Windows 10
- Windows 7
- Windows 8
- Windows 8.1
- Word 2010
- Word 2013
- Word Online