Blog

Now that you know proper list guidelines and advanced sorting, you’re ready for automatic subtotals.

I love this feature!

With automatic subtotals, you can quickly total groups of sorted data. And, what’s more, automatic subtotals create three levels of outlining so you can quickly switch between viewing all of your data, just the subtotals and just the grand total.

Creating Automatic Subtotals
1. Sort your list according to where you want your subtotals
2. Click Subtotal in the Outline group on the Data tab
3. Change the field under At each change in
4. Choose your function
5. Choose which field(s) to which you want to add subtotals
6. Click OK

Removing Automatic Subtotals
1. Click anywhere inside your subtotaled list
2. Click Subtotal in the Outline group on the Data tab
3. Click Remove All

Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers.