Excel 2007: Automatic Subtotals

Excel 2007: Automatic Subtotals

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

I love this feature!

Figure 23. Subtotal Dialog Box

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.