ShortcutdrillExcel shortcuts / editing / AutoSum across a row
AutoSum across a row in Excel: Alt+= (Mac: Cmd+Shift+T)
| Windows | Alt+= |
|---|---|
| Mac | Cmd+Shift+T |
| Group | editing |
Drill: Total across a row. Pro drill. Twenty-five drills are free.
What it does and when to use it
With nothing above but numbers to the left, Alt+= sums across the row instead. Excel looks up first, then left.
The common mistake
Expecting a row sum when the cell above is a number too: AutoSum prefers the column. Select the row range first to force it.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
Can AutoSum do averages?
Alt+= is SUM only. Alt, H, U opens the AutoSum menu with Average, Count, Max and Min.
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