{"id":11073,"date":"2019-01-31T08:40:22","date_gmt":"2019-01-31T07:40:22","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=11073"},"modified":"2024-02-06T16:16:39","modified_gmt":"2024-02-06T15:16:39","slug":"show-field-and-value-settings-in-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-field-and-value-settings-in-excel-pivot-tables\/","title":{"rendered":"Show Field and Value Settings in Excel Pivot Tables"},"content":{"rendered":"<p>With Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> you can do a lot of stuff with your data! But did you know that you can edit your <strong>Field and Value Settings<\/strong>\u00a0in <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> in multiple places?<\/p>\n<p>Let me show you the different <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcuts\" data-wpil-keyword-link=\"linked\">shortcuts<\/a> so that you can tinker with your\u00a0<strong>Pivot Table<\/strong>!<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/xkjPc52f7SM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Field-Value-Field-Settings.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Let us have a look at the existing Pivot Table. To view the Field Settings, we can do the following:<\/p>\n<p>Under\u00a0<strong>PivotTable Fields &gt; Rows &gt; Field Settings<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11076\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-01.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"261\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-01.jpg 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-01-161x300.jpg 161w\" sizes=\"(max-width: 261px) 100vw, 261px\" \/><\/p>\n<p>You can also\u00a0<strong>right click\u00a0<\/strong>on a\u00a0<strong>Row Label<\/strong> and select\u00a0<strong>Field Settings.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11077\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-02.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"251\" height=\"561\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-02.jpg 251w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-02-134x300.jpg 134w\" sizes=\"(max-width: 251px) 100vw, 251px\" \/><\/p>\n<p>Or while having a row label selected, you can go to\u00a0<em><strong>PivotTable Tools &gt; Analyze &gt; Active Field &gt; Field Settings<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11078\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-03.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"770\" height=\"604\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-03.jpg 770w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-03-300x235.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-03-768x602.jpg 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/p>\n<p>And now you have your Field Settings open!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11079\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-04.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"420\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-04.jpg 420w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-04-300x294.jpg 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Now let us see how to access the <strong>Value Field Settings<\/strong>.<\/p>\n<p>Go to\u00a0<strong>PivotTable Fields &gt; Values&gt; Value Field Settings<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11080\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-05.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"356\" height=\"496\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-05.jpg 356w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-05-215x300.jpg 215w\" sizes=\"(max-width: 356px) 100vw, 356px\" \/><\/p>\n<p>You can also\u00a0<strong>right click\u00a0<\/strong>on a\u00a0<strong>Value<\/strong> and select <strong>Value\u00a0Field Settings.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11081\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-06.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"383\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-06.jpg 383w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-06-300x271.jpg 300w\" sizes=\"(max-width: 383px) 100vw, 383px\" \/><\/p>\n<p>Or while having a value selected, you can go to\u00a0<em><strong>PivotTable Tools &gt; Analyze &gt; Active Field &gt; Field Settings<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11082\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-07.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"793\" height=\"613\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-07.jpg 793w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-07-300x232.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-07-768x594.jpg 768w\" sizes=\"(max-width: 793px) 100vw, 793px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You now have your\u00a0<strong>Value Field Settings!<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Show Field and Value Settings in Excel Pivot Tables\"  class=\"aligncenter size-full wp-image-11083\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-08.jpg\" alt=\"Show Field and Value Settings in Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-08.jpg 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Field-Value-Field-Settings-08-300x257.jpg 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>How to Show Field and Value Field Settings In Pivot Tables<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With Excel Pivot Tables you can do a lot of stuff with your data! But did you know that you can edit your Field and Value Settings\u00a0in Pivot Table in multiple places? Let me show you the different shortcuts so that you can tinker with your\u00a0Pivot Table! \ufeff Download excel workbookField-Value-Field-Settings.xlsx &nbsp; STEP 1:\u00a0Let us [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17554,"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":[574,139,575],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11073"}],"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=11073"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11073\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17554"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=11073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=11073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=11073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}