Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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


Download Practice Workbook

You can download the Excel file from here.


4 Methods to Insert a Total Row in Excel

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 in Excel ( 5 Methods)


2. Insert a Total Row by Keyboard Shortcut

You can also use the keyboard shortcut to insert a total 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.

Read More: Shortcuts to Insert New Row in Excel (6 Quick Methods)


Similar Readings


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 to achieve the goal of this article.

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: VBA Macro to Insert Row in Excel Based on Criteria (4 Methods)


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 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 (2 Simple Examples)


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. Visit our site, ExcelDemy for more awesome articles like this.


Related Articles

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo