Pin Me

Microsoft Excel: My Manager Wants Subtotals Above The Data

written by: Mr Excel•edited by: Tricia Goss•updated: 11/18/2011

Problem: Your manager insists that subtotals for each rep appear above the data. There doesn’t appear to be any hope of the manager being reassigned to Minsk soon.

  • slide 1 of 2

    Strategy: Luckily, someone on the Excel team at Microsoft must have worked for your manager once. There is a setting on the Subtotals dialog to move the totals to the top of the section being subtotaled.

    As shown in Fig. 692, in the Subtotal dialog, uncheck the box for Summary Below Data.

    Result: As shown in Fig. 693, the Grand Total appears at the top of the dataset and the subtotal for each manager appears before records for that manager.

    Summary: You can easily add subtotals above each section being subtotaled.

    Commands Discussed: Subtotals

  • slide 2 of 2


    Fig. 692Fig. 693