» Fast Summation in Excel 2007

To sum the columns within the Current Region:
1. Select a cell in the Current Region/List and press Ctrl+Shift+*> or Ctrl+A.
2. Press Alt+=.
Or
Select Formulas -> AutoSum (in Function Library Group).
3. The SUM formula is added automatically at the bottom of each column.

To SUM all values in a list, in vertical and horizontal directions:

1. Select a range of cells containing values, including a blank row and a blank column surrounding the range by selecting the first cell in a table, pressing the Shift> key. Then select the blank cell in the first cross blank row and column (cell D4 in the screenshot below).
2. Press Alt+=.
Or
3. Select Formulas -> AutoSum (in Function Library Group).
4. The SUM formula is added at the end of each row and at the bottom of each column.

Before:



After:



To quickly sum values:

Select the range of cells along with a blank cell in a vertical or horizontal direction.
Press Alt+=.
Or
Select Formulas -> AutoSum (in Function Library Group).
The SUM formula is added to the blank cell.