Shortcut for AutoSum in Excel
AutoSum, which automatically produces the result of addition by specifying a range of cells. This function can be performed with shortcut keys. We encourage you to learn how to use the shortcut keys to streamline your work and increase your productivity.
Shortcut to perform AutoSum
Alt + = (equal)
Perform row or column AutoSum
For instructions on how to perform an AutoSum using a shortcut, see below. This section describes how to perform an AutoSum of column data.
Total Time: 1 minute
Select a cell
Select the cell where you want the result of the AutoSum to appear.
Enter AutoSum as a shortcut
Press Alt + = (equal). The SUM function will automatically populate. Cell ranges can be changed manually.
Calculation of the SUM function is complete
Press Ctrl + Enter. The sum calculated by the SUM function is reflected in the active cell.
Perform multi-row or column AutoSum
This section describes how to use a shortcut to AutoSum data in multiple columns. The same method can also be used to AutoSum multiple rows.
Select one cell in which you want the result of a multi-column AutoSum to appear.
Press Shift +→ (Right Arrow key) to make multiple cells selected.
Press Alt + = (equal). The results of an AutoSum of multiple columns will be displayed.
Performs an AutoSum of row and column totals
This section describes how to use a shortcut to display not only the respective totals for rows and columns, but also the row total and column total data in an AutoSum.
Select one cell that is the starting point for the data you want to AutoSum.
Press Shift +→ (Right Arrow key) several times. Select up to the cell (ex F2) where the row total is displayed.
Press Shift +↓ (Down Arrow key) several times. Select up to the cell (ex F7) where the sum of all selected cells is displayed.
Press Alt + = (equal). The totals for each row and column are now displayed respectively. The total for each row and column is also displayed in a cell (ex F7).