Add a Total Row in Excel

In Excel, when you are working with data, you might need to have a total at the bottom to have a sum of all the values that you have in each column.

add-total-row-in-data

In this tutorial, we will learn to add a row with the total using two quick methods.

  • Total Row in a Table.
  • Total with the Auto Sum.

Add a Total Row in Excel in a Table

  1. First, select any of the cells in the data and press the keyboard shortcut Ctrl + T, and click OK to apply the table.
    2-add-total-row-in-excel-table
  2. Next, go to the Table tab, and tick-mark the Total Row checkbox.
    3-tickmark-total-row-checkbox
  3. Here you have a total row at the bottom of the table where you have a total only for the last column.
    4-total-row-added-in-last-column
  4. Now you need to select the sum for each cell of the total row to get the sum of each column.
    5-select-sum-for-each-cell-of-rows
  5. Once you select SUM from the drop-down for each of the columns that you have on the table, you will have a total row.
    6-sum-total-row
  6. Once you apply the table to the data, you can right-click on it, then go to the table, and click on the total row from there.
    7-right-click-and-total-row-option

Add a Total Row with the Auto Sum

  1. First, select the row after the last row of the data.
    8-total-row-with-autosum
  2. After that, press that keyboard shortcut Alt + = (AutoSum) to add the sum function in all the cells in the row to make it a total row for the data.
    9-press-keyboard-shortcut-alt-plus-equal

Apart from this, once you select the bottom row, you can go to the Home Tab, Editing Group, and click on the auto sum button to add the sum function in all the cells.

home-tab-auto-sum-icon

The moment you click on the auto sum button, you get the total values in the row selected.