Insert a Total Row in MS Excel 2007

Dennis Faas's picture

In your table. you can sum up your data and have it in a total row. You may wish to place your total row at the bottom of spreadsheet or anywhere within your spreadsheet really.

Follow the steps below to learn how:

  • Click anywhere in your table of data and this will open the Table Tools | Design tab.  
  • Click it and you will see check boxes in Table Style Options.  
  • Check Total Row to have it instantly added.  
  • Then click each cell I the total row to select a function such as SUM, AVERAGE, etc. from the drop-down menu.

That's all there is to it!

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet