{"id":4600,"date":"2025-02-13T01:01:00","date_gmt":"2025-02-13T06:01:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4600"},"modified":"2025-02-11T11:00:40","modified_gmt":"2025-02-11T16:00:40","slug":"sort-multiple-columns-in-excel-step-by-step","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2025\/02\/13\/sort-multiple-columns-in-excel-step-by-step\/","title":{"rendered":"Sort Multiple Columns in Excel Step-by-Step"},"content":{"rendered":"<p>Sorting data in Excel is quick and easy, if you only need to sort by a single column, or even two columns. For a large table, sorting can be more complicated, if you need to sort by 3 or more columns. Today, I&#8217;ll show you how to <strong>sort multiple columns in Excel<\/strong> so your data is quickly organized the way you need it. Whether you&#8217;re sorting by two, three, or more columns, this guide will help you through it!<\/p>\n<p><!--more--><\/p>\n<h2>Video: Sort Multiple Columns in Excel<\/h2>\n<p>In this short video, I show how to sort an Excel list by multiple columns. First, there&#8217;s a 2-level sort, using the Quick Sort buttons. Next, I show a 3-level sort, using the Sort dialog box.<\/p>\n<p>There are written steps below the video.<\/p>\n<p><iframe loading=\"lazy\" title=\"Sort Excel List by Multiple Columns\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/I-X9Rv4RyoQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2>Step 1: Start with Your Data<\/h2>\n<p>First, you need to have your data ready. For example, you might have a table with sales orders sorted by their invoice number.<\/p>\n<ul>\n<li><strong>Tip<\/strong>: Before you start sorting, make a backup copy of your Excel file. This is good practice, in case something goes wrong while sorting.<\/li>\n<\/ul>\n<p>But now, you need to do a report, and you want to sort it by region and then by the sales rep within each region.<\/p>\n<p>Here&#8217;s what your data might look like:<\/p>\n<figure style=\"width: 400px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2025\/02\/sortmulticolumn01.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"sales orders sorted by their invoice number\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2025\/02\/sortmulticolumn01_thumb.png\" alt=\"sales orders sorted by their invoice number\" width=\"400\" height=\"275\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">sales orders sorted by their invoice number<\/figcaption><\/figure>\n<h2>Step 2: Using Quick Sort for Simple Sorting<\/h2>\n<p>If you only have a couple of columns to sort, the quickest way is to use the Quick Sort buttons. You can find these buttons on your Quick Access Toolbar or the Data tab in Excel. Here&#8217;s how:<\/p>\n<ul>\n<li>Select any cell in the column you want to sort.<\/li>\n<li>Click the <strong>A to Z<\/strong> button to sort alphabetically.<\/li>\n<li>Next, sort the other column. For example, if you want to sort by region, select the region column and click <strong>Z to A<\/strong>.<\/li>\n<\/ul>\n<p>Now your list should show the regions in alphabetical order, with the sales reps sorted within each region.<\/p>\n<h2>Step 3: Plan Your Sort Steps<\/h2>\n<p>When sorting, remember to start with the least important column first.<\/p>\n<p>For this example, we want this sorting structure:<\/p>\n<ol>\n<li>Regions A-Z<\/li>\n<li>Sales reps A-Z, under each region.<\/li>\n<\/ol>\n<p>Sales reps are level 2 in the sorted results that we want, so they&#8217;ll be sorted first. Regions will be sorted second<\/p>\n<figure style=\"width: 400px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2025\/02\/sortmulticolumn03.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Sales reps are level 2 importance in sort\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2025\/02\/sortmulticolumn03_thumb.png\" alt=\"Sales reps are level 2 importance in sort\" width=\"400\" height=\"275\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Sales reps are level 2 importance in sort<\/figcaption><\/figure>\n<h2>Step 4: Use Sort Dialog Box for More Levels<\/h2>\n<p>If you want to do a more complex sort, like sorting by three levels (for example, sales rep, item sold, and cost), you should use the Sort dialog box:<\/p>\n<ul>\n<li>Select any cell in your table.<\/li>\n<li>Go to the <strong>Data<\/strong> tab and click on <strong>Sort<\/strong>.<\/li>\n<\/ul>\n<p>This will open the Sort window. Here you can set multiple levels of sorting:<\/p>\n<ol>\n<li>In the first dropdown, select the column you want to sort by first (in this example, it\u2019s the sales rep).<\/li>\n<li>Then click <strong>Add Level<\/strong> to add more sorting criteria (like items sold and cost).<\/li>\n<li>Make sure to set the order for each column (A to Z for names, smallest to largest for costs).<\/li>\n<\/ol>\n<p>Click <strong>OK<\/strong> to see your sorted data.<\/p>\n<figure style=\"width: 337px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2025\/02\/sortmulticolumn05.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"data sorted by region then by sales rep\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2025\/02\/sortmulticolumn05_thumb.png\" alt=\"data sorted by region then by sales rep\" width=\"337\" height=\"359\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">data sorted by region then by sales rep<\/figcaption><\/figure>\n<h2>Step 5: Review the Sorted Data<\/h2>\n<p>After sorting, take quick look at your sorted data. Make sure that everything looks right and that the rows of data didn&#8217;t get jumbled accidentally.<\/p>\n<ul>\n<li>That &#8220;jumbling&#8221; can happen if the entire table didn&#8217;t get sorted, just some of the columns. Usually, that&#8217;s caused by a blank column somewhere in the list.<\/li>\n<\/ul>\n<p>If something seems off, you can always hit <strong>Undo<\/strong> to go back to the original order.<\/p>\n<h2>More Sorting Tips<\/h2>\n<p>For more Excel multi-column sorting tips, and to get the sample file, go to the <a title=\"Sort Multiple Columns in Excel\" href=\"https:\/\/www.contextures.com\/excelsortmultiplecolumns.html\" target=\"_blank\" rel=\"noopener\">Sort Multiple Columns in Excel<\/a> page, on my Contextures site.<\/p>\n<p>Also, get <a title=\"Sort Data in Excel &amp; Avoid Problems\" href=\"https:\/\/www.contextures.com\/xlsort01.html\" target=\"_blank\" rel=\"noopener\">tips for safely sorting Excel data<\/a>, to avoid problems. For example, see how you can avoid a VLOOKUP sorting problem that I ran into!<\/p>\n<h2>More Sorting Tutorials<\/h2>\n<p><a href=\"https:\/\/www.contextures.com\/xlsort01.html\">Sort Data in Excel<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/xlSort02.html\">Sort Data With Macros<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/excel-pivot-table-sorting.html\">Pivot Table Sorting<\/a><\/p>\n<p>_______________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sorting data in Excel is quick and easy, if you only need to sort by a single column, or even two columns. For a large table, sorting can be more complicated, if you need to sort by 3 or more columns. Today, I&#8217;ll show you how to sort multiple columns in Excel so your data &hellip; <a href=\"https:\/\/exceltheatre.com\/blog\/archives\/2025\/02\/13\/sort-multiple-columns-in-excel-step-by-step\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Sort Multiple Columns in Excel Step-by-Step&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":4599,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-4600","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4600"}],"version-history":[{"count":3,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4600\/revisions"}],"predecessor-version":[{"id":4605,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4600\/revisions\/4605"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4599"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}