AutoSum in Excel (macOS)
Press Shift + Command + T 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 |
|---|---|
| macOSthis page | Shift + Command + T |
| Windows |
More Excel shortcuts: Cells and Formula bar
- Enter Date
- Enter Time
- Toggle Formulas
- AutoComplete List
- Expand Formula Bar
All 95 Excel shortcuts for macOSThe full list has a search and a printable PDF.
Questions
What is the Excel shortcut for AutoSum on macOS?
⇧⌘T (Shift + Command + T). Press it to insert a SUM formula for the numbers next to the cell.
What is the shortcut for AutoSum in Excel on Windows?
On Windows it is Alt+=.