{"id":23653,"date":"2022-01-12T11:25:57","date_gmt":"2022-01-12T10:25:57","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23653"},"modified":"2024-02-06T15:50:28","modified_gmt":"2024-02-06T14:50:28","slug":"show-hide-field-headers-in-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-hide-field-headers-in-pivot-table\/","title":{"rendered":"Show\/Hide Field Headers in Excel Pivot Tables"},"content":{"rendered":"

\"Show\/Hide<\/a><\/p>\n

Whenever you work with Pivot Tables<\/a>, you can see the Row Labels<\/strong> and Column Labels<\/strong> that are automatically generated on top. This is handy as they can be used to filter out your records<\/strong>.<\/p>\n

But, Pivot Table<\/a> being a tool for the presentation of data as well, you might want to hide these labels as well for making the data set more presentable<\/strong>. It is easy to Show\/Hide Field Headers in a Pivot Table. Let us see how!<\/p>\n

 <\/p>\n

Exercise Workbook:<\/strong><\/em><\/p>\n

\n

download excel workbook<\/strong><\/i><\/span>Show-or-Hide-Field-Headers.xlsx<\/span><\/a><\/p>\n

\n<\/div>\n

\n

This is our pivot table. And you can see the 2 field headers on top:<\/p>\n

\"Show\/Hide<\/p>\n

STEP 1:<\/strong><\/span> Go to\u00a0PivotTable Analyze > Show > Field Headers<\/strong><\/em><\/p>\n

Click on it to hide the field headers:<\/p>\n

\"Show\/Hide<\/p>\n

And they are now hidden!<\/p>\n

\"Show\/Hide<\/p>\n

You can click on the same button to show them again.<\/p>\n

\"Show\/Hide<\/p>\n

The headers will be visible again!<\/p>\n

\"Show\/Hide<\/p>\n

 <\/p>\n

Make sure to download our FREE PDF on the\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Whenever you work with Pivot Tables, you can see the Row Labels and Column Labels that are automatically generated on top. This is handy as they can be used to filter out your records. But, Pivot Table being a tool for the presentation of data as well, you might want to hide these labels as […]<\/p>\n","protected":false},"author":2,"featured_media":25397,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4],"tags":[888,139,887],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23653"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23653"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23653\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25397"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}