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: Keyboard Shortcuts. Microsoft Windows has always had some fantastic time-saving keyboard shortcuts designed to make our lives easier. For example: CTRL-X will cut text or objects, and CTRL-V will paste them. (Of course, you can use your mouse to achieve the same thing, but it requires clicking and fumbling through menus, which can be a huge time waster if you cut and paste 50+ times a day). With Windows 8, Microsoft has added many new keyboard shortcuts to their operating system; unfortunately, it's a bit of a learning curve. That's where the Windows 8 keyboard shortcuts cheat sheet comes in! Simply download the guide and reference it when you need to. You'll save a ton of time using your keyboard, rather than reaching for the mouse and flipping through oodles of menus trying to find what you're looking for. 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.