AutoSum, Quick Calculations & Keyboard Shortcuts
AutoSum, Quick Calculations & Keyboard Shortcuts
Excel includes built in calculation tools that let you add up numbers, find averages, and get quick results without typing formulas from scratch.
In this blog, we’ll look at AutoSum, Quick Calculations, and the keyboard shortcuts that make everyday tasks faster.
You may need more advanced formulas later, but AutoSum covers roughly 80% of everyday needs for most basic users.
AutoSum: The Fastest Way to Add Numbers
AutoSum automatically adds a column or row of numbers for you. Excel will select either the column above or the row to the left of the cell containing the total.
AutoSum is perfect for:
Budgets
Expenses
Sales totals
How to Use AutoSum
1. Click the empty cell below a column of numbers (or to the right of a row)
2. Select Home Ribbon
3. Click on AutoSum
4. Press Enter