O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Subtotaling data values

Subtotaling cell values is another common calculation task that Excel can perform for you. You can find the Subtotal tool on the Data tab, in the Outline group.

Subtotal data values

  1. Select the data, including column headers, for which you want a subtotal.

  2. Click the Data tab.

  3. Click Subtotal.

  4. Select when you want the function to be applied.

  5. Choose the subtotal function that you want to use.

  6. Select what you want to subtotal.

  7. Choose the check box to specify where you want the subtotal to appear.

  8. Click OK.

image with no caption

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required