Auto Sum Shortcut in Excel

Auto Sum into Cell below Column

Click into an empty cell below the column (it doesn’t have to be immediately below the last number), then press ALT =

This displays the SUM function in the cell. At this point you can either press ALT = again, or press ENTER to accept.

You can also check Excel Shortcut Keyboard Keys

Select Region before Auto Sum

If the current cell is in the column you want to sum, press CTRL+A to select all of the numbers in the column, then press ALT =

Use Mouse to Select Region before Auto Sum

Use your mouse to select the cells you want to sum, making sure the last cell is empty as this is where the auto sum will go.

You can also see How to Data Analysis Using Excel

Auto Sum a Row

Click into an empty cell beside the row (it doesn’t have to be immediately beside the row), then press ALT =

This displays the SUM function in the cell. As with a column, press ALT = again or press ENTER to accept.

Select Region before Auto Sum

If the current cell is in the row you want to sum, press CTRL+A to select all of the numbers in the row, then press ALT =

Use Mouse to Select Region before Auto Sum

Use your mouse to select the cells you want to sum, making sure the last cell is empty as this is where the auto sum will go.

Auto Sum Multiple Columns and Rows

Click and select empty cells below the columns (it doesn’t have to be immediately below the last number), then press ALT =

This time the sum for each column is automatically inserted below that column.

You can also read Excel VLOOKUP Function

Select Multiple Columns before Auto Sum

If the current cell is in one of the columns you want to sum (only adjacent columns will be selected), press CTRL+A to select all of the adjacent columns, then press ALT =

Use Mouse to Select Multiple Columns before Auto Sum

Use your mouse to select the columns you want to sum, making sure the last cell is empty as this is where the auto sum will go.

Auto Sum Multiple Rows

Click and select empty cells beside the rows (they don’t have to be immediately beside the last number), then press ALT =

The sum for each row is automatically inserted beside the row.

Use Mouse to Select Multiple Rows

Use your mouse to select the rows you want to sum, including an empty cell at the end of each row where the auto sum will go.

Leave a Reply

Translate ยป
%d bloggers like this: