Page 6 of 15PREVNEXT

Lists I: How to use lists in Excel 2003

Using the Toggle Total Row button on the List toolbar

Callout 1 Click the Toggle Total Row button on the List toolbar...
Callout 2 ...to add a Total row to the list.

There's also a new List toolbar in Excel 2003. Some of the buttons on the toolbar provide SharePoint® functionality, which is not covered in this course. But the button you'll want to learn about right away is the Toggle Total Row button.

This button automatically totals the last column in the list. To get a total in column C of the example, you would just click the Toggle Total Row button. Voilà! Excel would add an additional row with the word "Total" and with the sum. Note that if the last column contained something that couldn't be summed, such as a column of names, Excel would count the number of items instead.

In the Quick Reference Card you'll see how to do calculations on columns other than the last one.

Tip     You can turn off the total by clicking the Toggle Total Row button again. The Total row disappears.

Page 6 of 15PREVNEXT