» Fast Summation

Using keyboard shortcuts

To sum the columns within the Current Region:

1. Select a cell in the Current Region/List and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A).
2. Press Alt+=.
OR
Click the AutoSum icon (sigma) on the Standard toolbar.

The SUM formula is added automatically at the bottom of each column.

To add the SUM function to a vertical and horizontal range:

1. Select the range of cells containing values, including an empty row and column surrounding the cells by selecting the first cell in data table, pressing Shift, and then selecting the empty cell in the first cross empty row and column (cell D8 in the screenshot below).
2. Press Alt+=.
OR
Click the AutoSum icon.

The SUM formula is added to the end of each row and the bottom of each column.

To quickly sum values in a range:

1. Select the range of cells along with an empty cell in a vertical or horizontal direction.
2. Press Alt+=.
OR
Click the AutoSum icon.

The SUM formula is added to the empty cell.
Screenshot // Fast Summation