{"id":1456,"date":"2015-07-01T19:18:09","date_gmt":"2015-07-01T17:18:09","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1456"},"modified":"2024-02-06T15:45:40","modified_gmt":"2024-02-06T14:45:40","slug":"sort-field-list-in-a-excel-pivot-table-from-a-to-z","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-field-list-in-a-excel-pivot-table-from-a-to-z\/","title":{"rendered":"Sort Field List In a Pivot Table from A to Z"},"content":{"rendered":"<p>Do you ever get in a situation where 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> Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List?<\/p>\n<p>Well you can save time by sorting the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/field-list-activate-move-resize-layout\/\" target=\"_blank\" rel=\"noopener\">Pivot Table Field List<\/a> in alphabetical order!<\/p>\n<p>To do this you need to Right Click anywhere within your Piovot Table and choose <em><strong>PivotTable Options &gt; Display &gt; Sort A to Z<\/strong><\/em><\/p>\n<p>See how this is done below&#8230;<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/w_kbgsdSl0s?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><\/p>\n<p><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><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-from-A-to-Z.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Sort-Field-List-from-A-to-Z.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Our <strong>Field List<\/strong> is not sorted in alphabetical order as you can see here:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Sort Field List In a Pivot Table from A to Z\"  class=\"alignnone size-full wp-image-23385\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-01.jpg\" alt=\"Sort Field List In a Pivot Table from A to Z\" width=\"1006\" height=\"588\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-01.jpg 1006w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-01-300x175.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-01-768x449.jpg 768w\" sizes=\"(max-width: 1006px) 100vw, 1006px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span><strong>Right click<\/strong> in your Pivot Table and select <strong>PivotTable Options<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Sort Field List In a Pivot Table from A to Z\"  class=\"alignnone size-full wp-image-23386\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-02.jpg\" alt=\"Sort Field List In a Pivot Table from A to Z\" width=\"634\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-02.jpg 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-02-300x224.jpg 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Select <em><strong>Display &gt; Sort A to Z<\/strong><\/em>. Click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Sort Field List In a Pivot Table from A to Z\"  class=\"alignnone size-full wp-image-23387\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-03.jpg\" alt=\"Sort Field List In a Pivot Table from A to Z\" width=\"457\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-03.jpg 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-03-287x300.jpg 287w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/p>\n<p>And just like that, our Pivot Table Fields are now <strong>sorted from A to Z<\/strong>!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Sort Field List In a Pivot Table from A to Z\"  class=\"alignnone size-full wp-image-23388\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-04.jpg\" alt=\"Sort Field List In a Pivot Table from A to Z\" width=\"1016\" height=\"591\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-04.jpg 1016w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-04-300x175.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Sort-Field-List-In-a-Pivot-Table-04-768x447.jpg 768w\" sizes=\"(max-width: 1016px) 100vw, 1016px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List? Well you can save time by sorting the Pivot Table Field List in alphabetical order! To do this you need to Right Click anywhere [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Sort Field List In a Pivot Table from A to Z","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[17,4],"tags":[87,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1456"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1456"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1456\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17665"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}