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: Getting Started: Your Guide to Windows 8. Windows 8 is arguably Microsoft's most daring Windows Operating system to date. Featuring an unusual tile-based Start screen that's optimized for touchscreen devices, Windows 8 is now available on all new computers, laptops and ultrabooks, and hybrid tablets. Whichever device you use Windows 8 on, you'll need to know a few things. First, how are you going to get the data from your current operating system to the new one? Second, you'll probably be wondering where Windows desktop has gone. Finally, you might be wondering: why did Microsoft remove the Start menu? This eBook answers all those questions, and more. 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.
Need tech support? Chat with Dennis now using the chat button near the bottom left of the screen.