1-866-245-5224 sales@keystonelearning.com

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.

Creating Automatic Subtotals

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

Removing Automatic Subtotals

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