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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
