AutoSum shortcut
Select the empty cell under a column of numbers and press Alt+=. Excel writes the SUM formula and guesses the range; press Enter to accept it. On a Mac the shortcut is Cmd+Shift+T, which browsers use to reopen a tab, so this page only simulates it on Windows keys.
Try it: press the keys on this sheet
Windows and Mac keys
| Action | Windows | Mac |
|---|---|---|
| AutoSum | Alt+= | ⌘⇧T |
| Fill down | Ctrl+D | ⌘D or ⌃D |
| Toggle absolute reference ($) | F4 | ⌘T or F4 |
| Show formulas | Ctrl+` | ⌃` |
Shortcut not working?
AutoSum picks the wrong range
It stops at the first blank or text cell. Drag to select the right range before pressing Enter, or select the numbers plus the empty cell first and then press Alt+=.
Alt+= types an equals sign
Press both keys together, not one after the other. On some laptops the right-hand Alt is AltGr and won't work; use the left Alt.
The total shows 0
The numbers are probably stored as text. Look for green triangles in the corners and convert them with Text to Columns or VALUE.
Frequently asked questions
What is the AutoSum shortcut in Excel?
Alt+= on Windows. On a Mac it is Cmd+Shift+T. Both insert a SUM formula for the numbers above or to the left of the selected cell.
Can I AutoSum several columns at once?
Yes. Select the empty cells under all the columns and press Alt+= to add a total to each one.
Does AutoSum work for average or count?
The shortcut always inserts SUM. Use the arrow next to the AutoSum button on the Home tab to pick Average, Count, Max or Min.