Skip to content

How to add a total row in Excel?

  • by
  • 3 min read

Microsoft Excel is a powerful application that is used to get meaning out of the huge amount of information stored. It can do basic calculations to complex calculations on its own. The grid of cells unlocks the potential of Excel which can contain text, numbers and even formulas. It can store almost all kinds of information, and it is really easy to analyse and record numerical and statistical data using the Office 365 tool.

In this article, we have discussed how to add a total row to your spreadsheet in Excel in a few simple and easy steps.

Adding a total row in Excel

If you have made a table in the spreadsheet on Excel and want to add a total row in your spreadsheet then follow the steps below.

Step 1: Open your document in Excel and then place your cursor anywhere in the table for which you want to create a total row and then click on the Table Design tab from the menu at the top of the screen.

Step 2: In Table Style Options, checkmark the box beside the Total Row option.

Step 3: A total row will be created for the table

Also read: How to delete a column in Excel?

How to change the action of the total row?

Excel allows its users to change the actions of the cell in the total row for all the columns in the table, If you want to change the action of the cells in the total row of different columns in your table then follow the steps below.

Step 1: Click on the cell in the total row whose action you want to change, an arrow will appear on the right side of the cell, click on the Arrow button.

Step 2: In the drop-down menu, select the action you want to choose for the cell.

Step 3: As you can see in the image below the action of the column is changed, earlier it was summing the data in the column and now it has given the average of the data in the column. You can use this method to change actions for all the columns.

Also read: How to delete Excel rows?


Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: [email protected]