About this lesson
Shortcuts: move, select and sum without the mouse
Ctrl+↓ (⌘↓ on Mac) jumps to the end of a block of data, and adding Shift selects everything on the way. Alt+= (⇧⌘T on Mac) inserts a SUM of the numbers above the active cell.
This lesson is a shortcut drill, so it needs a physical keyboard.
=SUM(B2:B21)Worked example
Jump to the end of a 20-store revenue table, select a whole column of revenue and total it with AutoSum, all from the keyboard.
| Cell | What it works out | Formula | Result |
|---|---|---|---|
| B22 | TotalRevenue ($m) | =SUM(B2:B21) | 1,156 |
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Store | Revenue ($m) | EBITDA margin | Staff (FTE) |
| 2 | Bondi Junction | 86 | 12.4% | 310 |
| 3 | Parramatta | 74 | 11.8% | 268 |
| 4 | Chatswood | 69 | 13.1% | 247 |
| 5 | Castle Hill | 58 | 9.7% | 205 |
| 6 | Miranda | 63 | 10.9% | 226 |
| 7 | Macquarie Park | 71 | 12.2% | 251 |
| 8 | Penrith | 52 | 8.8% | 190 |
| 9 | Liverpool | 47 | 8.3% | 172 |
| 10 | Hornsby | 44 | 10.1% | 158 |
| 11 | Burwood | 39 | 9.4% | 141 |
| 12 | Newcastle | 55 | 11.2% | 198 |
| 13 | Wollongong | 41 | 8.6% | 149 |
| 14 | Gosford | 33 | 7.2% | 121 |
| 15 | Canberra Centre | 66 | 11.5% | 236 |
| 16 | Chadstone | 92 | 14.1% | 334 |
| 17 | Highpoint | 49 | 9.1% | 176 |
| 18 | Doncaster | 57 | 10.5% | 204 |
| 19 | Southland | 61 | 11.9% | 219 |
| 20 | Carindale | 54 | 10.7% | 195 |
| 21 | Garden City | 45 | 9.3% | 162 |
| 22 | Total |