Excel Hack

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

Windows
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 a cell

Select the cell where you want the result of the AutoSum to appear.

Enter AutoSum as a shortcut

Check cell range

Press Alt + = (equal). The SUM function will automatically populate. Cell ranges can be changed manually.

Calculation of the SUM function is complete

Displaying AutoSum result

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 a cell

Select one cell in which you want the result of a multi-column AutoSum to appear.

Select multiple cells

Press Shift + (Right Arrow key) to make multiple cells selected.

Calculate the total value with a shortcut

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 a cell

Select one cell that is the starting point for the data you want to AutoSum.

Select up to a cell to calculate the row data and results

Press Shift + (Right Arrow key) several times. Select up to the cell (ex F2) where the row total is displayed.

Select data including cells for calculating totals

Press Shift + (Down Arrow key) several times. Select up to the cell (ex F7) where the sum of all selected cells is displayed.

Calculate the total value with a shortcut

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).

Articles related to AutoSum & Shortcut