AutoSum in Excel (Windows)
Press Alt + Equals to insert a SUM formula for the numbers next to the cell.
What it does
Excel looks at the cells above the active cell, or to its left, guesses the range of numbers and writes a SUM formula for it. The range is shown with a moving border so you can correct it before you confirm with Enter. With several cells selected under or beside a block of numbers, it fills in a sum for every column or row at once.
The same shortcut on other platforms
| Platform | Shortcut |
|---|---|
| Windowsthis page | Alt + Equals |
| macOS |
More Excel shortcuts: Formulas
- Show Formulas
- Array Formula
- Toggle Absolute Reference
- Accept AutoComplete
- Turn Formula Checking Tooltips On or Off
All 159 Excel shortcuts for WindowsThe full list has a search and a printable PDF.
Questions
What is the Excel shortcut for AutoSum on Windows?
Alt+= (Alt + Equals). Press it to insert a SUM formula for the numbers next to the cell.
What is the shortcut for AutoSum in Excel on macOS?
On macOS it is ⇧⌘T.