{"id":519066,"date":"2022-11-30T20:00:00","date_gmt":"2022-11-30T17:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/7-ways-to-sort-data-in-microsoft-excel\/"},"modified":"2022-11-30T20:00:00","modified_gmt":"2022-11-30T17:00:00","slug":"7-ways-to-sort-data-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/","title":{"rendered":"#7 Ways to Sort Data in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6acdb887f0956\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6acdb887f0956\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#%E2%80%9C7_Ways_to_Sort_Data_in_Microsoft_Excel%E2%80%9D\" >&#8220;7 Ways to Sort Data in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#A_to_Z_Sorting\" >A to Z Sorting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#Row_Sorting\" >Row Sorting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#Color_Sorting\" >Color Sorting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#Conditional_Formatting_Icon_Sorting\" >Conditional Formatting Icon Sorting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#List_Sorting\" >List Sorting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#New_List_Sorting\" >New List Sorting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/buradabiliyorum.com\/en\/7-ways-to-sort-data-in-microsoft-excel\/#Multi-Level_Sorting\" >Multi-Level Sorting<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9C7_Ways_to_Sort_Data_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;7 Ways to Sort Data in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<figure style=\"width: 1200px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage size-full wp-image-848824\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Colorful candies sorted by color into rows.\" width=\"1200\" height=\"675\"\/><figcaption class=\"wp-caption-text\"><span class=\"type:primaryImage imagecredit\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.shutterstock.com\/image-photo\/colorful-delicious-chocolate-candies-buttons-lying-1721808769\">Reda.G\/Shutterstock.com<\/a><\/span><\/figcaption><\/figure>\n<p>It\u2019s easy to sort data in Excel alphabetically or numerically. But maybe you want to sort based on color, formatting, or a list like months of the year. We\u2019ll show you different ways to sort data in Excel.<\/p>\n<p>You can use the quick sort for those basic options or create a custom sort that gives you more flexibility. Whatever your data, be it text or numbers, take a look at these various ways you can sort it.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"A_to_Z_Sorting\"><\/span>A to Z Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to sort by text in alphabetical order or numbers like currency or decimals in numerical order, you can do this in Excel in just a few clicks.<\/p>\n<p><strong>RELATED:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/400679\/how-to-sort-values-in-microsoft-excel\/\"><strong><em>How to Sort Values in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select the data you want to sort and open the Sort tool one of these ways:<\/p>\n<ul>\n<li>On the Home tab, select \u201cSort &amp; Filter\u201d in the Editing section of the ribbon. At the top of the pop-up box, choose \u201cSort A to Z\u201d or \u201cSort Z to A.\u201d<\/li>\n<li>On the Data tab, select \u201cA \u2013 Z\u201d or \u201cZ \u2013 A\u201d in the Sort section of the ribbon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847624\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/DataSortAZ-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sort options on the Data tab\" width=\"650\" height=\"364\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your data is\u00a0then sorted in the order you picked, either alphabetically from A to Z or the reverse. This option also sorts numbers the same way, from lowest to highest or the opposite.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-847626 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortedZtoA-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sorted data from Z to A\" width=\"650\" height=\"325\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also use the A to Z sorting when you create a custom sort which we\u2019ll describe next.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Row_Sorting\"><\/span>Row Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>For more advanced options in Excel like sorting by row instead of column, you can create a custom sort.<\/p>\n<p>Select your data, go to the Data tab, and click \u201cSort\u201d in the Sort &amp; Filter section of the ribbon. Then, click \u201cOptions\u201d at the top of the Sort box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847628\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortOptions-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Options button in the Sort box\" width=\"650\" height=\"298\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the small pop-up box, mark the Sort Left to Right option, check the box for Case Sensitive at the top if you like, and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847627\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortLeftToRight-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sort Left to Right for rows\" width=\"260\" height=\"216\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can then continue setting up your sort by row with the drop-down boxes. Depending on the options you pick in the first drop-down boxes, you\u2019ll be able to sort from A to Z, top to bottom, or another option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847629\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortByRow-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Rows listed in the Sort by menu\" width=\"650\" height=\"298\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Color_Sorting\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Color Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Also using the custom sort option in Excel, you can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/803167\/excel-sort-by-color\/\">sort by color. This allows you to sort your data by the cell or font color. Select your data and then \u201cSort\u201d on the Data tab to open the Sort box.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Sort by Color in Microsoft Excel<\/em><\/strong><\/p>\n<p>Choose the following in the drop-down boxes:<\/p>\n<ul>\n<li><strong>Sort by<\/strong>: Pick the column or row.<\/li>\n<li><strong>Sort on<\/strong>: Pick either \u201cCell Color\u201d or \u201cFont Color\u201d depending on what you want to sort. Then, use the additional box that appears to select the color.<\/li>\n<li><strong>Order<\/strong>: Pick \u201cOn Top\u201d or \u201cOn Bottom\u201d per your preference.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847630\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortByColor-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sort by color settings\" width=\"650\" height=\"195\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cOK\u201d when you finish, and you\u2019ll see your data sorted by your chosen color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847631\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortedByColor-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data sorted by color\" width=\"559\" height=\"389\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Conditional_Formatting_Icon_Sorting\"><\/span>Conditional Formatting Icon Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you take advantage of <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/736339\/how-to-use-icon-sets-to-represent-values-in-microsoft-excel\/\">displaying icons for your data in Excel based on conditional formatting, you can use this as a sort option too. Select your data and then \u201cSort\u201d on the Data tab to open the Sort box.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Icon Sets to Represent Values in Microsoft Excel<\/em><\/strong><\/p>\n<p>Choose the following in the drop-down boxes:<\/p>\n<ul>\n<li><strong>Sort by<\/strong>: Pick the column or row.<\/li>\n<li><strong>Sort on<\/strong>: Pick \u201cConditional Formatting Icon\u201d and then use the additional box that appears to pick the icon.<\/li>\n<li><strong>Order<\/strong>: Pick \u201cOn Top\u201d or \u201cOn Bottom\u201d per your preference.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847633\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortByIcon-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"230\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cOK\u201d when you finish, and you\u2019ll see your data sorted by your chosen conditional formatting icon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847632\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortedByIcon-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"315\" height=\"244\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"List_Sorting\"><\/span>List Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One convenient sorting option many don\u2019t realize exists in Excel is list sorting. For instance, you may want to sort by day of the week or month of the year. Select your data and then \u201cSort\u201d on the Data tab to open the Sort box.<\/p>\n<p>Choose the following in the drop-down boxes:<\/p>\n<ul>\n<li><strong>Sort by<\/strong>: Pick the column or row containing the list items.<\/li>\n<li><strong>Sort on<\/strong>: Pick \u201cCell Values.\u201d<\/li>\n<li><strong>Order<\/strong>: Pick \u201cCustom List.\u201d Then choose an existing list in the Custom Lists section and click \u201cOK.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847636\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SelectList-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Available lists to sort by\" width=\"650\" height=\"414\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the list appear in the Order drop-down menu in the Sort box. Click \u201cOK\u201d to sort your data by the list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847635\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortByList-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"List added to the Sort box Order menu\" width=\"650\" height=\"193\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see your data sorted by your chosen list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847634\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortedByList-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data sorted by a list\" width=\"544\" height=\"369\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"New_List_Sorting\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_5\">New List Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another way to sort using a list is with a new custom list. This is convenient if you haven\u2019t had time to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/707962\/how-to-create-a-custom-list-in-microsoft-excel\/\">create the custom list in Excel yet, because you can make it with the sort tool. Select your data and then \u201cSort\u201d on the Data tab to open the Sort box.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a Custom List in Microsoft Excel<\/em><\/strong><\/p>\n<p>Choose the following in the drop-down boxes:<\/p>\n<ul>\n<li><strong>Sort by<\/strong>: Pick the column or row containing the list items.<\/li>\n<li><strong>Sort on<\/strong>: Pick \u201cCell Values.\u201d<\/li>\n<li><strong>Order<\/strong>: Pick \u201cCustom List.\u201d Select \u201cNew List,\u201d click \u201cAdd,\u201d and then enter each list item in the List Entries box. Be sure to enter them in the order you want them. Click \u201cOK\u201d when you finish.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847639\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/CreateList-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Create a new list and entries box\" width=\"650\" height=\"414\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the list in the Sort box\u2019s Order drop-down menu. Click \u201cOK\u201d to sort your data by this list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847638\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortByCreatedList-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"List added to the Sort box Order menu\" width=\"650\" height=\"237\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then have your data sorted by the new custom list you just created.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847637\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/SortedByCreatedList-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Data sorted by a custom list\" width=\"289\" height=\"189\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Multi-Level_Sorting\"><\/span>Multi-Level Sorting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019d like to sort by more than one column or row in Excel, you can add another level when you create a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/846892\/how-to-use-the-microsoft-excel-sort-function\/\">custom sort. For example, you might sort alphabetically by name first and color second. And, you can add levels to any of the above sorting methods if you like.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use the Microsoft Excel SORT Function<\/em><\/strong><\/p>\n<p>In the Sort box, set up your first sort option with the drop-down boxes. Then, choose \u201cAdd Level\u201d and set up the secondary sort you want to use.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847641\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/AddLevel-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add Level button in the Sort box\" width=\"650\" height=\"298\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Keep in mind that, Excel sorts your data based on this list of levels from top to bottom. So if needed, you can rearrange them. Select a level and then use the arrow buttons to move that level up or down.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-847640\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/MoveLevel-ExcelWaysSortData.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Multiple sort levels and arrows to rearrange them\" width=\"650\" height=\"298\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish, click \u201cOK\u201d to apply the sort for your multiple levels.<\/p>\n<hr\/>\n<p>Sorting your data in Microsoft Excel helps you see it the way you need to for analysis or review. So keep these sorting methods in mind and also look at how to sort by date in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/847610\/ways-to-sort-data-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;7 Ways to Sort Data in Microsoft Excel&#8221; Reda.G\/Shutterstock.com It\u2019s easy to sort data in Excel alphabetically or numerically. But maybe you want to sort based on color, formatting, or a list like months of the year. We\u2019ll show you different ways to sort data in Excel. You can use the quick sort for those&#8230;<\/p>\n","protected":false},"author":1,"featured_media":519067,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-519066","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/519066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=519066"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/519066\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/519067"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=519066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=519066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=519066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}