ShortcutdrillExcel shortcuts / formula / Total a whole block at once
Total a whole block at once in Excel: Select the block plus a blank row and column, Alt+= (Mac: Cmd+Shift+T)
| Windows | Select the block plus a blank row and column, Alt+= |
|---|---|
| Mac | Cmd+Shift+T |
| Group | formula |
Drill: Sum across a block. Pro drill. Twenty-five drills are free.
What it does and when to use it
Select the numbers together with the empty row below and the empty column to the right, then Alt+=. Excel fills the edges with SUMs, including the grand total in the corner.
The common mistake
Selecting only the numbers, which puts the sums under each column but not across the rows.
Related shortcuts
- Show formulas instead of values Ctrl+`
- Create names from labels Select labels and values, Ctrl+Shift+F3, Enter
- Insert a function by name Shift+F3, type the name, Enter
- Add a note to a cell Shift+F2, type, Esc
- Repeat the last action F4 (or Ctrl+Y)
- The printable cheat sheet
Questions
How do I add row and column totals to a table?
Select the table plus one blank row and one blank column, then Alt+=.
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