ShortcutdrillExcel shortcuts / editing / Total two columns in a row
Total two columns in a row in Excel: Alt+=, Tab, Alt+= (Mac: Option+=, Tab, Option+=)
| Windows | Alt+=, Tab, Alt+= |
|---|---|
| Mac | Option+=, Tab, Option+= |
| Group | editing |
Drill: Totals for two columns. Pro drill. Twenty-five drills are free.
What it does and when to use it
Alt+= writes the first SUM, Tab confirms it and moves right, Alt+= writes the second. Three presses for two totals. Selecting the whole blank row and pressing Alt+= once also works.
The common mistake
Pressing Enter after the first AutoSum, which moves down instead of right.
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
Why Tab instead of Enter?
Enter moves down after confirming; Tab moves right. Use whichever direction the next formula goes.
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