✅ Get the sample Excel file to follow along: myctx.link/Ptstyle

When you add fields to the value area in a pivot table, custom names are automatically created, such as Sum of Quantity. See how to remove the "Sum of" in the label, without an Excel error message. Also, see how to hide any (blank) labels in the pivot table.

💡 Related Links 💡
Pivot table style and formatting tips ► myctx.link/Ptstyle

🔴 Related Excel Videos 🔴
Change Excel Pivot Table Report Layout ► [ Ссылка ]
Manually Move Excel Pivot Table Labels ► [ Ссылка ]
Quick Trick - Add & Move Pivot Fields ► [ Ссылка ]

✅ Excel resources I recommend ► [ Ссылка ]

⏰ Video Timeline ⏰
0:00 Create Pivot Table
0:33 Remove "Sum of" in Headings
2:01 Fix Blank Label Cells

Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: [ Ссылка ]
Subscribe to Contextures YouTube: [ Ссылка ]
#ContexturesExcelTips

свернуть