Insert a Total Row in MS Excel 2007
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 CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!