How to Add a Total Row in MS Excel?

how to add a total row in ms

When there are a number of columns with numerical data, say the price details of a few products sold on different days, for instance, it’s a common practice for anyone to want to know how much has been sold in terms of quantity & revenue. So, in this article, we are going to explore the different ways to add a Total Row at the bottom of the data.

  1. Using the Keyboard Shortcut
  2. Using the Formulas Tab
  3. Using SUM Formula

We would be trying to add the quantity and price details of the below dataset using each of the above listed methods.

Sample Dataset 2
A Random Sales Data to Practice!

1. Using the Keyboard Shortcut

In this data, the totalling is to be done at row 11, just below the columns C, D, E which contains the numerical data. To get things started, select cells from C11 to E11 as shown below,

Selecting Cells for Total Row
Selecting Cells for a Total Row

This can be done by clicking on cell C11 and dragging the mouse till it reaches cell E11. For those who are having a hard time dragging the mouse, the navigation keys come to the rescue!

After clicking on C11, press the SHIFT key on your keyboard & don’t lift the finger off while doing the next operation. Hit the right arrow key (→) until the selection reaches the cell E11.

Once done press the following keys one after the other on your keyboard,

ALT, “+” (PLUS)

One must focus on making sure that the ALT key is pressed & without lifting that finger, the + (PLUS) key is then pressed. Once it is done, the cells will be populated with the total figure of each of the columns as shown below,

Sum Total Appears
Sum Total Row Appears!

2. Using the Formulas Tab

This is for those who have a hard time remembering the keyboard shortcuts or would like to have a plan-B to add the total row. Selecting the required cells at the bottom of the dataset remains the same as stated in the previous method.

Selecting Cells for Total Row 1
Selecting the Cells for the Total Row

Once done, click on the Formulas Tab as shown in the below image,

Locating the Formulas Tab
Locating the Formulas Tab

Now, look for the Autosum command within the Formulas tab.

Locating the Autosum Command
Locating the Autosum command

Click on the Ʃ (Summation) symbol as highlighted in the above image & at once the total sum of the columns would appear in each cell selected at their very bottom.

Sum Total Appears 1
Totals successfully added

3. Using SUM Formula

We need not select the cells at the bottom of the columns with the numerical data in here as needed for the previous 2 methods. But we click on cell C11 to get things started.

Double click on the cell and type =SUM( within as shown in the below image.

Typing SUM Formula
Typing the SUM Formula

Once done, select all the numerical entries in the column above.

Selecting Cells for Totaling
Selecting the Column Range for Totalling

When you see something similar to the selection in the above image, it’s time to close the bracket which was opened right after we typed the word SUM.


Sum Total is Calculated
The Entire Quantity Sold is Totalled!

The total figure for all the entries of column C appears. Copy this cell and paste it on the cells D11 and E11 next to it.

Pasting the copied cell
Pasting the Formula on Adjacent Cells

It is now evident, that the total is summed up at the bottom of the entries in the columns D & E too.


Now we’ve covered 2 different ways to add a row with the sum total for a given dataset. Do check this article which covers how to multiply in MS Excel. For more such tricks and tips for using MS Excel, do watch out our space, QuickExcel. Cheers!