Shortcut keys
WindowsAlt + =
MacCmd + Shift + T
Ribbon path
Home → AutoSum
What it does
Automatically inserts a SUM formula for the cells above or to the left of the active cell. Works for multiple columns at once.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for autosum selected range?
On Windows, use Alt + =. On Mac, use Cmd + Shift + T.
Where is autosum selected range in the Excel Ribbon?
The Ribbon path is Home → AutoSum.
What does autosum selected range do in Excel?
Automatically inserts a SUM formula for the cells above or to the left of the active cell. Works for multiple columns at once.