How to Use the AutoSum Shortcut in Excel
Select the cell where you want to insert the Sum function., Press the shortcut for your system., Press ↵ Enter or use Ctrl+↵ Enter to be in same cell.
Step-by-Step Guide
-
Step 1: Select the cell where you want to insert the Sum function.
Excel will automatically analyse the nearby cells to see what should be added (generally, it adds all the rows above the given cell, or all the columns to the left of the cell).
However, if you want to change, you can change it.
In Windows, press Alt+= at the same time.
On a Mac, press ⌘ Cmd+⇧ Shift+T at the same time.
Or, on any computer, you can select the Autosum button from the Excel menu/ribbon. , -
Step 2: Press the shortcut for your system.
-
Step 3: Press ↵ Enter or use Ctrl+↵ Enter to be in same cell.
Detailed Guide
Excel will automatically analyse the nearby cells to see what should be added (generally, it adds all the rows above the given cell, or all the columns to the left of the cell).
However, if you want to change, you can change it.
In Windows, press Alt+= at the same time.
On a Mac, press ⌘ Cmd+⇧ Shift+T at the same time.
Or, on any computer, you can select the Autosum button from the Excel menu/ribbon. ,
About the Author
Doris Richardson
Writer and educator with a focus on practical lifestyle knowledge.
Rate This Guide
How helpful was this guide? Click to rate: