ShortcutdrillExcel shortcuts / editing / AutoSum below a column
AutoSum below a column in Excel: Alt+= (Mac: Cmd+Shift+T)
| Windows | Alt+= |
|---|---|
| Mac | Cmd+Shift+T |
| Group | editing |
Drill: Total in one key press. Free, no sign-up.
What it does and when to use it
In the cell below a column of numbers, Alt+= writes =SUM() over the numbers above. Press Enter to confirm. It finds the range itself, stopping at the first text or blank.
The common mistake
Pressing Enter without checking the range. A blank cell in the column makes AutoSum stop short of the top.
Related shortcuts
- AutoSum across a row Alt+=
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- The printable cheat sheet
Questions
How do I AutoSum several columns at once?
Select the blank row under all of them and press Alt+=. One formula per column appears.
What is AutoSum on a Mac?
Cmd+Shift+T in Excel for Mac. Option+= also works in recent versions.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill