AutoSum shortcut
Windows
Alt=Mac
⌘cmd⇧shiftTClick the cell below a column of numbers and press Alt+= (Cmd+Shift+T on a Mac). Excel writes =SUM() for the adjacent range; press Enter to accept.
Try it now
Click the pad below, then press the shortcut. Nothing happens to this page; we just listen.
Alt=
Waiting for your keys…
Practise it with the rest of the set
One shortcut sticks better alongside its neighbours. These trainers include it:
Questions
What is the autosum shortcut?
Click the cell below a column of numbers and press Alt+= (Cmd+Shift+T on a Mac). Excel writes =SUM() for the adjacent range; press Enter to accept.