{"id":271,"date":"2014-09-24T17:14:54","date_gmt":"2014-09-24T15:14:54","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=271"},"modified":"2024-06-10T01:16:40","modified_gmt":"2024-06-09T23:16:40","slug":"sorting-a-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sorting-a-pivot-table\/","title":{"rendered":"Sorting a Pivot Table"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sorting-a-pivot-table\/#Sorting_a_Pivot_Table\" title=\"Sorting a Pivot Table\">Sorting a Pivot Table<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Sorting_a_Pivot_Table\"><\/span>Sorting a Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are a few ways that you can <em>Sort<\/em> a <a class=\"wpil_keyword_link\" title=\"Pivot Table\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a>.\u00a0 You can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/sort\/\" target=\"_blank\" rel=\"noopener\">Sort<\/a> the Row\/Column Labels as well as Values within a Pivot Table.\u00a0 Below I show you three quick ways&#8230;<\/p>\n<p><span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Sort.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Sort.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> You can sort by<strong> dragging the cell value<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19767\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-01.jpg\" alt=\"Sorting a Pivot Table\" width=\"557\" height=\"279\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-01.jpg 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-01-300x150.jpg 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/p>\n<p>This is now the sorted result:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19768\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-02.jpg\" alt=\"Sorting a Pivot Table\" width=\"565\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-02.jpg 565w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-02-300x162.jpg 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> You can also sort by<strong> typing an existing cell value<\/strong><\/p>\n<p>In our example, we are typing Widget Corp, which is currently located at the last row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19769\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-03.jpg\" alt=\"Sorting a Pivot Table\" width=\"569\" height=\"294\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-03.jpg 569w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-03-300x155.jpg 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/p>\n<p>123 Warehousing gets pushed down, and Widget Corp moves to the top row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19770\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-04.jpg\" alt=\"Sorting a Pivot Table\" width=\"563\" height=\"297\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-04.jpg 563w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-04-300x158.jpg 300w\" sizes=\"(max-width: 563px) 100vw, 563px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> You can also sort by<strong> right clicking. <\/strong><\/p>\n<p>Try it on any company name and select <em><strong>Sort &gt; Sort A to Z<\/strong><\/em><\/p>\n<p>Our table will be sorted in alphabetical order based on the company name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19771\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-05.jpg\" alt=\"Sorting a Pivot Table\" width=\"588\" height=\"483\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-05.jpg 588w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-05-300x246.jpg 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/p>\n<p>Try it also on the Grand Total column. <strong>Right click<\/strong> and select <em><strong>Sort &gt; Sort Smallest to Largest<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19772\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-06.jpg\" alt=\"Sorting a Pivot Table\" width=\"945\" height=\"458\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-06.jpg 945w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-06-300x145.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-06-768x372.jpg 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/p>\n<p>Our table is now sorted in ascending order by the Grand Total values!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19773\" title=\"Sorting a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-07.jpg\" alt=\"Sorting a Pivot Table\" width=\"590\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-07.jpg 590w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/sort-pivot-table-07-300x178.jpg 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sorting a Pivot Table There are a few ways that you can Sort a Pivot Table.\u00a0 You can Sort the Row\/Column Labels as well as Values within a Pivot Table.\u00a0 Below I show you three quick ways&#8230; download workbookSort.xlsx STEP 1: You can sort by dragging the cell value This is now the sorted result: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17544,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Sorting a Pivot Table","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[38,4,20],"tags":[86,90],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/271"}],"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=271"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/271\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17544"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}