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.



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:




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.