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

Excel 2003: Automatic Subtotals

Excel 2003: Automatic Subtotals

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. Choose Data: Subtotals… from a Menu bar
     

Figure 9: Subtotal Dialog Box

   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.  
  3. Choose Data: Subtotals… from a Menu bar
     
  4.  
  5. Click Remove All