Inserting a total row in your Excel sheet will help you summarize the data.

While managing a number-based dataset, you might often include a subtotal row at the end.

And that too in tabular format.

how-to-add-total-row-in-an-excel-table

But, sometimes, adding a total row can split the Table format if not implemented properly.

Ive shared the proper methods of including a total row in Excel to avoid that issue.

Keep reading till the end of this article.

select-cells-go-to-insert-table-and-select-table

go for the range of rows you want to get a total result for; pressCtrl+Shift+Ton your keyboard.

Youll notice a total row is added at the end of the selected rows.

you might follow further procedures if the shortcut method doesnt work.

go-to-table-design-tab-and-click-on-total-row

First, you should probably use the table format to add rows.

But its not mandatory.

you might add rows without creating a table in Excel.

select-table-and-click-on-totals-row

Well further discuss the procedure of creating a total row without a design tab.

Now lets get back to where we started.

Read more on how toCombine First and Last Names in MS Excel.

type-new-formula-to-add-total-row-in-a-table

Here are the methods to add total row in MS Excel:

1.

For that, youll need a table with your data.

If the data arent included in a table, create a new one.

navigate-to-table-click-on-table-row

Select your data to create a new table and navigate toInsert > Table.

Then proceed to the following steps to include a total row at the end.

By default, it will be sum total of the columns.

But you could change it.

Also, check out our separate post on how toInstall Macro in Excel.

it’s possible for you to modify the rows functionality after that.

Heres a complete guide on how toCopy Values Without Formulas on Excel.

Different functions and formulas are the ones that make Excel more flawless.

However, some users find the excel formula hard to implement.

Since youre here, there is no need to worry about that.

Just follow my instructions to include a new formula to add total rows.

D2 is the first cell, and D16 is the last cell.

So, the formula would be=Subtotal(9,C2:E17).

you’re free to try any of these methods and get the same result.

Check out our separate post onHighlight Duplicate Values in Excel.

Now, if you have any further queries related to adding a total row, follow the subsequent section.

Frequently Asked Questions

How do I add Total Row in an Excel Table?

Can I Add an Extra row in Excel Web?

Can I use a Formula to add the Totals row?

Using a formula is the safest method for inserting Totals rows in an Excel table.

Nevertheless, if you find any issues while following the instructions Ive included here, just comment below.

A group of Excel experts is ready to answer your queries 24/7.