Total Row in Excel helps us to get a quick summary of different columns from a table. 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 price, quantity purchased, and total price. Now we will insert a total row in this dataset and get the summary in this row.
Download Practice Workbook
4 Methods to Insert a Total Row in Excel
1. Insert a Total Row from Table Design Tab
To insert a total row, first, you have to create a table with your data. To create a table select your data and then go to Insert > Table.
After that, a 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.
Now, your data will be shown as a table.
After creating the table, you can easily add the Total Row to the table. Go to the Table Design tab and check on Total Row.
After checking the total row you will see a new row named Totals has been created at the end of your table. It will by default show the summation of the last column.
Now you can get different kinds of information from the total Row. Suppose we want to know the Unit price (per KG) for all the items in the list. To perform the calculation, select the cell of the total row in the Unit price (per KG) column. Now a small downward arrow will appear. Click on the arrow and you will see the list of calculations you can perform in the total row.
You can also apply other functions by clicking on More Functions. However, To know the total Unit price we need to calculate the average Unit price of all items. So we need to select Average from the dropdown list.
After selecting Average, you will get the average of the column Unit Price (Per KG) in the Total Row.
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. First, create a table following the beginning of Method-1.
Then select any cells of the table and press CTRL+SHIFT+T. As a result, the total row will be inserted at the end of the table.
- How to Insert Rows Automatically in Excel (3 Ways)
- How to Move a Row in Excel (6 Methods)
- Macro to Insert Multiple Rows in Excel (6 Methods)
- How to Insert a Row within a Cell in Excel (3 Simple Ways)
- Excel Macro to Add Row to the Bottom of a Table
3. Total Row From Context Menu
Total Row can also be inserted from the Right Click Context Menu. Right click on any cell of your table, you can see a context menu will appear. Go to Table and expand it, then select Totals Row from this context menu.
After that, the Total Row will be inserted at the end of the table.
You can also perform the other calculations as shown in Method 1 by methods 2 and 3.
4. Insert a Total Row by Formula
You can also insert a total Row by manually creating a row in the table and applying the SUBTOTAL function in that row. First, type Total in the cell below the last cell of your table and press ENTER. It will automatically add a row at the end of the table.
Now type the following formula in cell D15 to get the total price,
Here, 9 indicates that the SUBTOTAL function will sum up the selected cells. And D6:D14 are the selected cells.
Press ENTER, you will get the total price for all items in cell D15.
You can use the SUBTOTAL function to make other calculations. For example to find the Average unit price, type the formula in cell B15,
Here, 1 indicates that the SUBTOTAL function will give the average of the selected cells. And B6:B14 are the selected cells.
Press ENTER, you will get the Unit price for all items in cell B15
We can get the 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.
- How to Insert Multiple Blank Rows in Excel (4 Easy Ways)
- Excel Fix: Insert Row Option Greyed out (9 Solutions)
- How to Insert Row Below in Excel (5 Methods)
- VBA to Insert Row in Excel (11 Methods)
- Insert Rows in Excel Based on Cell Value with VBA (2 Methods)
- Cannot Insert Row in Excel (Quick 7 Fixes)