Show Values Row in Excel Pivot Table Headings

Watch this video to see how to show values row in Excel Pivot Table headings, and why the command sometimes doesn't change anything.

Get the sample workbook for this video from the Pivot Table Options page on my website:
https://www.contextures.com/excelpivo...

Some pivot tables do not have a Values Row, and sometimes the Values Row cannot be hidden.

This video shows the pivot table layout that you need, to create a Values Row. It also shows when the Values Row can be hidden, and when it can't be hidden.

To learn about the Pivot Power Premium (PPP) Excel addin from Contextures, go to this page:
https://www.contextures.com/xlPivotPr...

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...

• #education
• #show_values_row_in_excel_pivot_table_headings
• #pivot_table
• #excel_pivot_table
• #pivot_table_values
• #pivot_table_headings
• #pivot_table_options
• #pivot_table_settings
• #values_for_in_pivot_table
• #show_values_row
• #excel_pivot_table_values
• #microsoft_excel
• #excel_tutorial
• #excel_tips
• #debra_dalgleish
• #contextures
• #contextures_inc