Change How Subtotals are Viewed in Excel

Question

How to change how subtotals are viewed in Excel?

Answer

Excel has numerous ways to alter the appearance of the PivotTable.  Another way is by changing how the subtotals appear.  To do this go to the Design tab and select the Subtotals icon. There will be a drop-down menu with three options. Select all three options to observe how it formats the subtotals on the pivot table.

For more information about Pivot Tables in Excel, please view the full tutorial from the CTL here: Excel Part 4

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7983
Created
Fri 12/30/22 1:54 PM
Modified
Fri 11/3/23 4:11 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.