{"id":368849,"date":"2021-11-17T19:00:33","date_gmt":"2021-11-17T16:00:33","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-alphabetize-data-in-microsoft-excel\/"},"modified":"2021-11-17T19:00:33","modified_gmt":"2021-11-17T16:00:33","slug":"how-to-alphabetize-data-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-alphabetize-data-in-microsoft-excel\/","title":{"rendered":"#How to Alphabetize Data in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a4bb094983a8\" 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-6a4bb094983a8\" 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-alphabetize-data-in-microsoft-excel\/#How_to_Alphabetize_a_Column_in_Microsoft_Excel\" >How to Alphabetize a Column in Microsoft Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-alphabetize-data-in-microsoft-excel\/#How_to_Alphabetize_a_Row_in_Microsoft_Excel\" >How to Alphabetize a Row in Microsoft Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Alphabetize Data in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Keeping your data organized in your Microsoft Excel spreadsheets is important. One way of doing that is by\u00a0alphabetizing your data, in either ascending or descending order. We\u2019ll show you how to do this in both rows and columns.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Alphabetize Lists and Tables in Microsoft Word<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Alphabetize_a_Column_in_Microsoft_Excel\"><\/span>How to Alphabetize a Column in Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/687875\/how-to-sort-by-multiple-columns-in-google-sheets\/\">To sort data A to Z (descending) or Z to A (ascending) in a column, use Excel\u2019s quick sort option. This option moves the relevant data in other columns as well so your table remains intact.<\/p>\n<p>To get started, open your spreadsheet with Microsoft Excel. In the spreadsheet, click the header of the column in which you want to alphabetize data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761435\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/1-select-column.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a column in Excel.\" width=\"650\" height=\"473\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In Excel\u2019s ribbon at the top, click the \u201cData\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761436\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/2-excel-data-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;Data&quot; tab in Excel.\" width=\"650\" height=\"483\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cData\u201d tab, under the \u201cSort &amp; Filter\u201d section, you will find options to alphabetize your data. To sort your data A to Z, click the \u201cAZ\u201d icon. To sort your data Z to A, click the \u201cZA\u201d icon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761437\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/3-alphabetize-column-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;AZ&quot; or &quot;ZA&quot; sort option in Excel.\" width=\"650\" height=\"225\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>A \u201cSort Warning\u201d window will open. This window suggests that you allow Excel to adjust the data in other columns so your data remains intact. Enable the \u201cExpand the Selection\u201d option and then click \u201cSort.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761438\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/4-excel-sort-warning.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enable &quot;Expand the Selection&quot; and click &quot;Sort&quot; in the &quot;Sort Warning&quot; window in Excel.\" width=\"642\" height=\"280\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And instantly, Excel will alphabetize your data in your spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761439\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/5-alphabetized-column-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An alphabetized column in Excel.\" width=\"650\" height=\"471\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019re all set.<\/p>\n<p>If you want, you can sort by date in Excel, too.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Sort by Date in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Alphabetize_a_Row_in_Microsoft_Excel\"><\/span>How to Alphabetize a Row in Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To alphabetize the data in a row in Excel, you will have to configure an additional option.<\/p>\n<p>To do so, first, launch your spreadsheet with Microsoft Excel.<\/p>\n<p>In the spreadsheet, select the entire table whose data you want to alphabetize. Do not select any table headers. In the following spreadsheet, we will not select \u201cName,\u201d \u201cAge,\u201d \u201cCity,\u201d and \u201cCountry\u201d as they are table headers.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761440\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/6-select-table.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the table in Excel.\" width=\"650\" height=\"380\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/714701\/how-to-switch-back-to-the-classic-ribbon-in-microsoft-office\/\">In Excel\u2019s ribbon at the top, click the \u201cData\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761441\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/7-data-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;Data&quot; tab in Excel.\" width=\"650\" height=\"223\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cData\u201d tab, under the \u201cSort &amp; Filter\u201d section, click \u201cSort.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761442\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/8-sort-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Sort&quot; in the &quot;Sort &amp; Filter&quot; section of the &quot;Data&quot; tab in Excel.\" width=\"650\" height=\"221\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cSort\u201d window that opens, at the top, click \u201cOptions.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761443\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/9-sort-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;Options&quot; on the &quot;Sort&quot; window in Excel.\" width=\"650\" height=\"298\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You will see a \u201cSort Options\u201d box. Here, select \u201cSort Left to Right\u201d and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761444\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/10-sort-left-to-right.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Sort Left to Right&quot; and click &quot;OK&quot; in the &quot;Sort Options&quot; box in Excel.\" width=\"287\" height=\"264\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Back on the \u201cSort\u201d window, click the \u201cSort By\u201d drop-down menu and select the row which you want to alphabetize. Then click the \u201cOrder\u201d drop-down menu and select either \u201cA to Z\u201d or \u201cZ to A\u201d sorting.<\/p>\n<p>Finally, at the bottom of the \u201cSort\u201d window, click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761445\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/11-alphabetize-rows-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Configure the sort options on the &quot;Sort&quot; window in Excel.\" width=\"650\" height=\"298\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely, Excel will alphabetize the selected data in your spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761446\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/12-alphabetized-rows.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An alphabetized row in Excel.\" width=\"650\" height=\"379\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And you\u2019re all set.<\/p>\n<hr\/>\n<p>On a related note, there are many other ways to sort and filter data in your Excel spreadsheets. Check out our guide on that to learn what those options are.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Sort and Filter Data in Excel<\/em><\/strong><\/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\/761432\/how-to-alphabetize-data-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Alphabetize Data in Microsoft Excel&#8221; Keeping your data organized in your Microsoft Excel spreadsheets is important. One way of doing that is by\u00a0alphabetizing your data, in either ascending or descending order. We\u2019ll show you how to do this in both rows and columns. RELATED: How to Alphabetize Lists and Tables in Microsoft Word&#8230;<\/p>\n","protected":false},"author":1,"featured_media":368850,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-368849","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\/368849","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=368849"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/368849\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/368850"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=368849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=368849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=368849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}