How to insert total row in Excel
By
SpreadCheaters
Page last updated:
09/01/2023 |
Next review date:
09/01/2025
You can watch a video tutorial here.
Excel has the provision to define a set of data as a Table. This is a useful feature especially when you need to create totals and calculated columns. It also becomes easy to add data and reference data when it is defined as a table. One of the table design options available is the option to insert a row that contains a total of all the numeric values in the table.
Step 1 – Summon the Table Design menu
– Select any cell in the table
– The Table Design menu is summoned
Step 2 – Insert the total row
– Go to Table Design > Table Style Options
– Tick Total Row
– A row for totals is added
Step 3 – Create the totals for all columns
– In the total row for each column, select the cell
– Expand the dropdown
– Select Sum
Step 4 – Check the result
– A row of totals is added to the table.
