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!
Free eBook: Windows 7 - The Pocket Guide. Windows 7 is by far the most favorite and widely-used Microsoft operating system to date, and, there are literally thousands of customizations you can apply to it. This pocket guide will help you customize your Windows 7 PC and make it work in the easiest and most optimized way possible. The eBook is written in an easy to understand manner, whether you're a newbie or seasoned pro user. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.