AutoSum in Excel (Alt+= / ⌘⇧T)
Click the empty cell below a column of numbers, then press Alt+= on Windows or ⌘⇧T (Command+Shift+T) on the Mac to drop in a SUM formula.
| Action | Mac | Windows | |
|---|---|---|---|
| Insert AutoSum (SUM) | ⌘⇧T | Alt+= | |
| Confirm the formula | Return | Enter |
Sum a column or row instantly
Select the empty cell just below a column of numbers (or just to the right of a row), then press Alt+= on Windows or ⌘⇧T on the Mac. Excel guesses the range and inserts =SUM(...); press Enter / Return to confirm.
Check the range before you confirm
Excel highlights the range it chose. If it is wrong, drag to select the correct cells before pressing Enter.
FAQ
What is the AutoSum shortcut in Excel?
Press Alt+= on Windows or ⌘⇧T (Command+Shift+T) on the Mac, then press Enter to confirm.
Can AutoSum add a row instead of a column?
Yes — select the empty cell to the right of a row of numbers and use the same shortcut.
Why is the range wrong?
AutoSum guesses the range. If it is wrong, drag to select the cells you want before pressing Enter.