Instead of adding up an entire column to the bottom of the worksheet, you can add-up only the rows containing data. To see how many rows Excel has, select a cell in a blank column then you use the shortcut: CTRL + Down Arrow to navigate to the last row in the worksheet. Instead, you can use a formula like this =SUM(A2:A1048576) Non-numerical values will be automatically excluded, but if the header is numeric, the pervious methods will not work well

You may need to add up an entire column (or row), except the header. To sum Non-Contiguous Columns or Rows at Once, enter the separate ranges (columns or rows) separated by commas: =SUM(A:A,B:B) Sum Non-Contiguous Columns or Rows at Once Then, while holding down SHIFT, use the arrow keys to select multiple rows. Remember that you can also use the keyboard shortcuts CTRL + SPACE to select an entire column or SHIFT + SPACE an entire row. To sum columns or rows at the same time, use a formula of the form: =sum(A:B) or =sum(1:2). Use the arrow keys to navigate to the column and using the SHIFT + SPACE shortcut to select the entire row.

Click the row number at the left of the worksheet.

To sum an entire row, use the same method as with columns:

Use the arrow keys to navigate to the column and using the CTRL + SPACE shortcut to select the entire column.

Click the column letter at the top of the worksheet.

To add up an entire column, enter the Sum Function: =sum( and then enter the desired column. Tip 3: Instead of using the keyboard, you can also use the mouse to drag and highlight the desired range and complete the formula. Then hold down SHIFT or CTRL + SHIFT to select the desired range of cells. Tip 2: After using the ALT + = shortcut or after typing =sum(, use the arrow keys to select the appropriate cell. When possible, Excel will guess which cells you would like to sum together, populating the Sum Function. Tip 1: The shortcut ALT + = (press and hold ALT then tap =) will automatically create a Sum Function. We will use the latter method to sum range A1 to E1: = SUM(A1:E1)

Standalone Cell References = sum(a1,b2,c3).

We will use the Sum Function to add up entire rows and columns.

How to add multiple rows in excel 2016