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 guide: Windows 8 Cheat Sheet: Touch and Mouse Gestures. Windows 8 brings a revolutionary way to use your mouse, touchpad, and touchscreen using 'gestures'. If you're new to gestures, you'll most certainly find them confusing - especially if you don't mean to invoke a gesture in the first place! That said, gestures are widely used on mobile and touch-based devices, and the technology is here to stay. Gestures can be a huge time-saver (similar to keyboard shortcuts) once you understand how to use them. For example, you can use gestures to move objects from one location to the next, zoom in, zoom out, enter passwords, and similar. This Windows 8 gesture cheat sheet is designed to make your life easier by demonstrating and explaining the basics. Print, share, and enjoy! Click here to download this guide now! Note: this guide 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.