{"id":19951,"date":"2022-11-30T17:29:12","date_gmt":"2022-11-30T17:29:12","guid":{"rendered":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/"},"modified":"2022-11-30T17:29:12","modified_gmt":"2022-11-30T17:29:12","slug":"7-ways-to-sort-data-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/","title":{"rendered":"7 Ways to Sort Data in Microsoft Excel"},"content":{"rendered":"<p> <a href=\"https:\/\/go.fiverr.com\/visit\/?bta=1052423&nci=17043\" Target=\"_Top\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" src=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-src=\"https:\/\/fiverr.ck-cdn.com\/tn\/serve\/?cid=40081059\"  width=\"601\" height=\"201\"><\/a>\n<\/p>\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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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 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 <a href=\"https:\/\/www.howtogeek.com\/702718\/how-to-sort-and-filter-data-in-excel\/\">sort data in Excel<\/a> 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\"><a name=\"autotoc_anchor_0\"\/>A to Z Sorting<\/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 href=\"https:\/\/www.howtogeek.com\/400679\/how-to-sort-values-in-microsoft-excel\/\"><strong><em>How to Sort Values in Microsoft Excel<\/em><\/strong><\/a><\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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 <a href=\"https:\/\/www.howtogeek.com\/400679\/how-to-sort-values-in-microsoft-excel\/\">sorts numbers<\/a> 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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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\"><a name=\"autotoc_anchor_1\"\/>Row Sorting<\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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\"><a name=\"autotoc_anchor_2\"\/>Color Sorting<\/h2>\n<p>Also using the custom sort option in Excel, you can <a href=\"https:\/\/www.howtogeek.com\/803167\/excel-sort-by-color\/\">sort by color<\/a>. 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> <a href=\"https:\/\/www.howtogeek.com\/803167\/excel-sort-by-color\/\"><strong><em>How to Sort by Color in Microsoft Excel<\/em><\/strong><\/a><\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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\"><a name=\"autotoc_anchor_3\"\/>Conditional Formatting Icon Sorting<\/h2>\n<p>If you take advantage of <a href=\"https:\/\/www.howtogeek.com\/736339\/how-to-use-icon-sets-to-represent-values-in-microsoft-excel\/\">displaying icons for your data in Excel<\/a> 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> <a href=\"https:\/\/www.howtogeek.com\/736339\/how-to-use-icon-sets-to-represent-values-in-microsoft-excel\/\"><strong><em>How to Use Icon Sets to Represent Values in Microsoft Excel<\/em><\/strong><\/a><\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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\"><a name=\"autotoc_anchor_4\"\/>List Sorting<\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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\"><a name=\"autotoc_anchor_5\"\/>New List Sorting<\/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 href=\"https:\/\/www.howtogeek.com\/707962\/how-to-create-a-custom-list-in-microsoft-excel\/\">create the custom list<\/a> 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> <a href=\"https:\/\/www.howtogeek.com\/707962\/how-to-create-a-custom-list-in-microsoft-excel\/\"><strong><em>How to Create a Custom List in Microsoft Excel<\/em><\/strong><\/a><\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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\"><a name=\"autotoc_anchor_6\"\/>Multi-Level Sorting<\/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 href=\"https:\/\/www.howtogeek.com\/846892\/how-to-use-the-microsoft-excel-sort-function\/\">custom sort<\/a>. 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> <a href=\"https:\/\/www.howtogeek.com\/846892\/how-to-use-the-microsoft-excel-sort-function\/\"><strong><em>How to Use the Microsoft Excel SORT Function<\/em><\/strong><\/a><\/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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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=\"https:\/\/mailinvest.blog\/wp-content\/themes\/breek\/assets\/images\/transparent.gif\" data-lazy=\"true\" data-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 <a href=\"https:\/\/www.howtogeek.com\/679749\/how-to-sort-by-date-in-microsoft-excel\/\">how to sort by date in Excel<\/a>.<\/p>\n<\/div>\n<iframe data-lazy=\"true\" data-src=\"https:\/\/www.fiverr.com\/gig_widgets?id=U2FsdGVkX18x7XQvttUTrv1oEqmGNGTgvvCUiUoJ\/AP4z\/UyMz8lXGOLpu15jIMxBbTR0gmD5uBoFvhC4KWeALQRp3h\/X\/AwcVD0K8Wj9H\/ZzYKzcCNHosB9oS4SCJJFWiN85P9ICAc4OgCoE\/wHKIY7CDkf2\/DQ1vqGvk4smVe5cRDEmrLPCWi4FC8p40VUhSmWQ5udCm0zoJtorgWv3vbDQw0kKYkwn39ozAnQXDe+YvWMxkLFWA+O3TFwkJvdkIK+\/AUSnRssPKt5WHY0FhNOxnSPcLslEL4G4\/RfP95ve99U+kRnDy3X+KtzdQLY+u935ghON\/o3UE4IMv9oN6JX9RnxzL\/LRcOgnHigxStSGPKsZYtnz8RWNVT\/rOLAibqiWJadC5MYHRbekF3eg6FOGrQGkXYbsn0+a5aovnlLCbLwIqY9fcS17UX8J235iQ6cdmHNbrPeS84CMm34RA==&affiliate_id=1052423&strip_google_tagmanager=true\" loading=\"lazy\" data-with-title=\"true\" class=\"fiverr_nga_frame\" frameborder=\"0\" height=\"350\" width=\"100%\" referrerpolicy=\"no-referrer-when-downgrade\" data-mode=\"random_gigs\" onload=\" var frame = this; var script = document.createElement('script'); script.addEventListener('load', function() { window.FW_SDK.register(frame); }); script.setAttribute('src', 'https:\/\/www.fiverr.com\/gig_widgets\/sdk'); document.body.appendChild(script); \" ><\/iframe>\n<br \/><a href=\"https:\/\/www.howtogeek.com\/847610\/ways-to-sort-data-in-microsoft-excel\/\">Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&#8230;<\/p>\n","protected":false},"author":1,"featured_media":19952,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-19951","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-universe"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>7 Ways to Sort Data in Microsoft Excel - mailinvest.blog<\/title>\n<meta name=\"description\" content=\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 Ways to Sort Data in Microsoft Excel - mailinvest.blog\" \/>\n<meta property=\"og:description\" content=\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"mailinvest.blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/freelanceracademic\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-30T17:29:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2392\" \/>\n\t<meta property=\"og:image:height\" content=\"1342\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin@mailinvest.blog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin@mailinvest.blog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/\"},\"author\":{\"name\":\"admin@mailinvest.blog\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/person\\\/012701c4c204d4e4ebd34f926cfd31a4\"},\"headline\":\"7 Ways to Sort Data in Microsoft Excel\",\"datePublished\":\"2022-11-30T17:29:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/\"},\"wordCount\":1078,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/shutterstock_1721808769.jpg\",\"articleSection\":[\"Tech Universe\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/\",\"name\":\"7 Ways to Sort Data in Microsoft Excel - mailinvest.blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/shutterstock_1721808769.jpg\",\"datePublished\":\"2022-11-30T17:29:12+00:00\",\"description\":\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/shutterstock_1721808769.jpg\",\"contentUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/shutterstock_1721808769.jpg\",\"width\":2392,\"height\":1342},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2022\\\/11\\\/30\\\/7-ways-to-sort-data-in-microsoft-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mailinvest.blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 Ways to Sort Data in Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#website\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/\",\"name\":\"mailinvest.blog\",\"description\":\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis. mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\",\"publisher\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mailinvest.blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\",\"name\":\"mailinvest\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/default.png\",\"contentUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/default.png\",\"width\":1000,\"height\":1000,\"caption\":\"mailinvest\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/freelanceracademic\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/person\\\/012701c4c204d4e4ebd34f926cfd31a4\",\"name\":\"admin@mailinvest.blog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"caption\":\"admin@mailinvest.blog\"},\"sameAs\":[\"https:\\\/\\\/mailinvest.blog\",\"admin@mailinvest.blog\"],\"url\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/author\\\/adminmailinvest-blog\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7 Ways to Sort Data in Microsoft Excel - mailinvest.blog","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"7 Ways to Sort Data in Microsoft Excel - mailinvest.blog","og_description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","og_url":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/","og_site_name":"mailinvest.blog","article_publisher":"https:\/\/www.facebook.com\/freelanceracademic\/","article_published_time":"2022-11-30T17:29:12+00:00","og_image":[{"width":2392,"height":1342,"url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg","type":"image\/jpeg"}],"author":"admin@mailinvest.blog","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin@mailinvest.blog","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/"},"author":{"name":"admin@mailinvest.blog","@id":"https:\/\/mailinvest.blog\/#\/schema\/person\/012701c4c204d4e4ebd34f926cfd31a4"},"headline":"7 Ways to Sort Data in Microsoft Excel","datePublished":"2022-11-30T17:29:12+00:00","mainEntityOfPage":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/"},"wordCount":1078,"commentCount":0,"publisher":{"@id":"https:\/\/mailinvest.blog\/#organization"},"image":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg","articleSection":["Tech Universe"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/","url":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/","name":"7 Ways to Sort Data in Microsoft Excel - mailinvest.blog","isPartOf":{"@id":"https:\/\/mailinvest.blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg","datePublished":"2022-11-30T17:29:12+00:00","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","breadcrumb":{"@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#primaryimage","url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg","contentUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/11\/shutterstock_1721808769.jpg","width":2392,"height":1342},{"@type":"BreadcrumbList","@id":"https:\/\/mailinvest.blog\/index.php\/2022\/11\/30\/7-ways-to-sort-data-in-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mailinvest.blog\/"},{"@type":"ListItem","position":2,"name":"7 Ways to Sort Data in Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/mailinvest.blog\/#website","url":"https:\/\/mailinvest.blog\/","name":"mailinvest.blog","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis. mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","publisher":{"@id":"https:\/\/mailinvest.blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mailinvest.blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mailinvest.blog\/#organization","name":"mailinvest","url":"https:\/\/mailinvest.blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mailinvest.blog\/#\/schema\/logo\/image\/","url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/01\/default.png","contentUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/01\/default.png","width":1000,"height":1000,"caption":"mailinvest"},"image":{"@id":"https:\/\/mailinvest.blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/freelanceracademic\/"]},{"@type":"Person","@id":"https:\/\/mailinvest.blog\/#\/schema\/person\/012701c4c204d4e4ebd34f926cfd31a4","name":"admin@mailinvest.blog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","caption":"admin@mailinvest.blog"},"sameAs":["https:\/\/mailinvest.blog","admin@mailinvest.blog"],"url":"https:\/\/mailinvest.blog\/index.php\/author\/adminmailinvest-blog\/"}]}},"_links":{"self":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/19951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/comments?post=19951"}],"version-history":[{"count":0,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/19951\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/media\/19952"}],"wp:attachment":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/media?parent=19951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/categories?post=19951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/tags?post=19951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}