Auto SUM Shortcuts in Excel | Excel Shortcuts Like A Pro |
Functions give you the ability to do a variety of things, like perform mathematical operations, look up values, or even calculate dates and times. Let's try a few ways to add up values with the SUM function.
To sum a column of numbers, select the cell immediately below the last number in the column. To sum a row of numbers, select the cell immediately to the right.
AutoSum is in two locations: Home → AutoSum, and Formulas → AutoSum.
You can also sum numbers by creating a simple formula.
Here's a neat keyboard shortcut. Select cell then press Alt + = then, Enter. This automatically enters SUM for you.
When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.