{"id":23520,"date":"2022-01-21T11:03:02","date_gmt":"2022-01-21T10:03:02","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23520"},"modified":"2024-02-06T15:50:34","modified_gmt":"2024-02-06T14:50:34","slug":"select-format-fields","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/select-format-fields\/","title":{"rendered":"Select &#038; Format Fields in Excel Pivot Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-Format-Fields.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25431\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-Format-Fields.png\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-Format-Fields.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-Format-Fields-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-Format-Fields-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>When it comes to<strong> select &amp; format fields in your <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><\/strong>, you can do it the manual way, or the easy way. Thankfully you can apply formatting to a specific section or the entire Pivot Table by following the steps below.<\/p>\n<p>I will show you different ways on how to utilize this!<\/p>\n<ul>\n<li><a href=\"#enable-selection\"><strong>Enable Selection in Pivot Table<\/strong><\/a><\/li>\n<li><a href=\"#select-pivot\"><strong>Select Entire Pivot Table<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><em><strong>Exercise Workbook:<\/strong><\/em><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format.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\">Select-format.xlsx<\/span><\/a><\/strong><\/p>\n<p class=\"line-two\">\n<\/div>\n<hr \/>\n<p>Here is our current Pivot Table:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23610\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-01.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"796\" height=\"544\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-01.jpg 796w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-01-300x205.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-01-768x525.jpg 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"enable-selection\"><\/a>Enable Selection in Pivot Table<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> To enable this, go to <em><strong>PivotTable Analyze &gt; Actions &gt; Select &gt; Enable Selection<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23611\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-02.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"489\" height=\"234\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-02.jpg 489w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-02-300x144.jpg 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Let us try it out! Select the <strong>Bottles Product<\/strong> from the left-hand side to highlight it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23612\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-03.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"468\" height=\"452\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-03.jpg 468w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-03-300x290.jpg 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/p>\n<p>Make any formatting change and it will apply to the entire <strong>Bottles Product<\/strong>. So this means we have targeted a specific product.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23613\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-04.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"461\" height=\"419\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-04.jpg 461w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-04-300x273.jpg 300w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> What if we want to apply a formatting change to all <strong>Product Labels<\/strong> in one click? Click on the top portion of <strong>Bottles<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23614\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-05.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"506\" height=\"470\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-05.jpg 506w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-05-300x279.jpg 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/p>\n<p>You will see all of the <strong>Product Labels<\/strong> got highlighted. Make any formatting change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23615\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-06.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"474\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-06.jpg 474w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-06-211x300.jpg 211w\" sizes=\"(max-width: 474px) 100vw, 474px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Let us now try on a specific quarter. Select the left-hand side of <strong>Q1<\/strong> to select it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23616\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-07.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"485\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-07.jpg 485w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-07-284x300.jpg 284w\" sizes=\"(max-width: 485px) 100vw, 485px\" \/><\/p>\n<p>Make any formatting change. And all <strong>Q1 values<\/strong> will immediately have this formatting change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23617\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-08.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"471\" height=\"680\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-08.jpg 471w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-08-208x300.jpg 208w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> You can do the same for a specific column. Click the 2014 column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23618\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-09.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"480\" height=\"457\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-09.jpg 480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-09-300x286.jpg 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/p>\n<p>Make the formatting change, and see the effects happen instantaneously!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone wp-image-23619 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-10.jpg\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"501\" height=\"695\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-10.jpg 501w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Select-format-10-216x300.jpg 216w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/p>\n<p>Once you have enabled selection in Pivot Table, you can easily apply formatting to any section.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"select-pivot\"><\/a>Select Entire Pivot Table<\/strong><\/span><\/p>\n<p>You can also <strong>use selection arrows to select the entire Pivot Table<\/strong> by following the steps below:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Move the <strong>cursor to the top-left cell<\/strong> of the Pivot Table<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25435\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-2.png\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"473\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-2.png 473w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-2-300x282.png 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Once the<strong> cursor changes to an arrow<\/strong>, <strong>click<\/strong> on the cell.<\/p>\n<p>The entire Pivot Table will be selected.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25434\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4.png\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"456\" height=\"446\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4.png 456w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4-300x293.png 300w\" sizes=\"(max-width: 456px) 100vw, 456px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em>Want an easier way than this? Luckily, Excel has that too!<\/em><\/p>\n<p>Go to <em><strong>PivotTable Analyze &gt; Actions &gt; Select &gt; Entire PivotTable<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25436\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-1.png\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"1101\" height=\"395\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-1.png 1101w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-1-300x108.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-1-1024x367.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-1-768x276.png 768w\" sizes=\"(max-width: 1101px) 100vw, 1101px\" \/><\/a><\/p>\n<p>The entire Pivot Table will be selected.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Select &amp; Format Fields in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25434\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4.png\" alt=\"Select &amp; Format Fields in Excel Pivot Tables\" width=\"456\" height=\"446\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4.png 456w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Select-4-300x293.png 300w\" sizes=\"(max-width: 456px) 100vw, 456px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-pivot-tables\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to know Top 50 things that you can do with Excel Pivot Table!<\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the <a href=\"https:\/\/app.monstercampaigns.com\/c\/yk5u6nmubly3hlfehsco\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>101 Best Excel Tips &amp; Tricks<\/strong><\/a>:<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When it comes to select &amp; format fields in your Pivot Table, you can do it the manual way, or the easy way. Thankfully you can apply formatting to a specific section or the entire Pivot Table by following the steps below. I will show you different ways on how to utilize this! Enable Selection [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":25431,"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":[904,902,903],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23520"}],"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=23520"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25431"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}