How to Insert a Total Row in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Total row in Excel helps us get a quick summary of different columns from a table or a range of cells. In this article, I’ll show you 4 easy and quick methods to insert a total row in Excel. Let’s say we have a dataset of different items, their prices, quantities purchased, and total prices. Now we will insert a total row in this dataset and get the summary in this row. The following image shows an overview of the methods for this article.

Overview of the various methods to insert a total row


Insert a Total Row in Excel: 4 Simple Methods

1. Insert a Total Row from Table Design Tab

I will convert the dataset to a table. Then, you will see a new tab called “Table Design” pop up in the ribbon. Then, from that tab, I will select an option to bring up the total row tab in Excel.

Steps:

  • Firstly, to insert the total row, you have to create a table with your data. To create a table, select your data and press Ctrl+T. Alternatively, after selecting the dataset, you can select Table from the Insert tab.
  • After that, a dialog box named Create Table will appear. If the range matches with the range of your dataset and My table has headers, is checked, then click OK on this box.

Create Table dialog box

  • Now, your data will be shown as a table.

A table is created

  • After creating the table, you can easily add the total row to the table.
  • So, select anywhere inside the table, then go to the Table Design tab and check on Total Row.
  • After checking the total row, you will see a new row named “Total” has been created at the end of your table. It will by default show the summation of the last column.

Table Design tab

  • Now, you can get different kinds of information from the total row. Now a small downward arrow will appear when the total row is selected. Click on the arrow and you will see the list of calculations you can perform in the total row.

Dropdown list after inserting a total row

  • You can also apply other functions by clicking on More Functions.
  • Then, select Sum for the cells C14 and D14 to get the total values.

Output of method 1

Read More: How to Insert Row Below in Excel


2. Insert a Total Row by Keyboard Shortcut

You can also use the keyboard shortcut to insert a total new row after creating a table. To do this follow the steps as mentioned below.

Steps:

  • First, create a table following the beginning of Method-1.
  • Then select any cells of the table and press Ctrl+Shift+T.

Shortcut to insert a total row

  • As a result, the total row will be inserted at the end of the table.

Output of method 2

  • Remember, you can also perform the other calculations as shown in the first method.

3. Bring Up Total Row from Context Menu

We can insert the total row from the right click context menu. In this section, we will select anywhere inside the data table and use the context menu.

Steps:

  • First, create a table following the beginning of Method-1.
  • Right click on any cell in your table, a context menu will appear.
  • Then, go to the table and expand it, then select Totals Row from this context menu.

Context menu for a table

  • After that, the total row will be inserted at the end of the table.

Output of Method 3

  • Remember, you can also perform the other calculations as shown in the first method.

Read More: How to Insert Rows in Excel Automatically


4. Using SUBTOTAL Function to Insert a Total Row

You can also insert a total row by manually creating a row in the table and applying the SUBTOTAL function to that row.

Steps:

  • Firstly, type Total in the cell below the last cell of your dataset and press Enter.
  • Secondly, type the following formula in cell C14 to get the total unit price.

=SUBTOTAL(9,C5:C13)

  • Here, 9 indicates that the SUBTOTAL function will sum up the selected cell, and C5:C13 is the selected cell range.

Using the SUBTOTAL function to Insert a total row

  • Thirdly, press Enter.
  • Then, use the Fill Handle tool to fill the formula into the rest of the cells on the right side.
  • Lastly, the output will be similar to this.

Output of method 4

Read More: Excel Formula to Insert Rows Between Data


Download Practice Workbook

You can download the Excel file from here.


Conclusion

We can get an overview of a table from the total row. I hope now you can easily insert a total row in your Excel data table. If you face any kind of confusion, please feel free to leave a comment.


Related Articles


<< Go Back to Insert Rows | Rows in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo