0
0
Excelspreadsheet~5 mins

AutoSum shortcut in Excel - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
AutoSum shortcut helps you quickly add numbers in a column or row without typing a formula. It saves time by automatically selecting the numbers to add and inserting the sum formula for you.
When you want to quickly add a list of sales numbers in a column.
When you need to find the total expenses in a row without typing =SUM manually.
When you want to add up scores from a group of students fast.
When you have a table of numbers and want to see the total at the bottom or side.
When you want to avoid errors from typing formulas by letting Excel do it for you.
Steps
Step 1: Select the cell below the column of numbers or to the right of the row of numbers
- Excel worksheet
The cell is highlighted and ready for the sum formula
💡 Make sure the numbers are in a continuous range without empty cells
Step 2: Press the AutoSum shortcut keys
- Keyboard
Excel inserts the =SUM formula automatically selecting the numbers above or to the left
💡 The shortcut keys are Alt + = (hold Alt and press the equals sign)
Step 3: Press Enter
- Keyboard
The sum of the selected numbers appears in the cell
💡 If the selection is wrong, you can adjust the range before pressing Enter
Before vs After
Before
Column A has numbers 10, 20, 30 in cells A1 to A3. Cell A4 is empty.
After
Cell A4 shows 60, the sum of numbers in A1 to A3 after using AutoSum shortcut.
Settings Reference
AutoSum button
📍 Home tab, Editing group
Quickly insert common formulas including sum
Default: Sum
Formula calculation mode
📍 Formulas tab, Calculation group
Controls when Excel recalculates formulas including AutoSum
Default: Automatic
Common Mistakes
Pressing the AutoSum shortcut in a cell with no numbers above or to the left
Excel cannot find numbers to sum and inserts an empty SUM formula
Select the correct cell next to the numbers before pressing the shortcut
Having blank cells in the number range
AutoSum may stop at the blank cell and not include all numbers
Ensure the numbers are in a continuous range without empty cells
Summary
AutoSum shortcut quickly adds numbers in a column or row without typing formulas.
Use Alt + = keys after selecting the cell below or beside numbers to sum.
Make sure numbers are in a continuous range for correct sum calculation.