{"id":8525,"date":"2021-11-29T16:40:53","date_gmt":"2021-11-29T16:40:53","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=8525"},"modified":"2024-03-28T10:44:49","modified_gmt":"2024-03-28T10:44:49","slug":"sort-multiple-rows-and-columns","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/","title":{"rendered":"Sort Multiple Rows and Columns in Excel"},"content":{"rendered":"\n
How-to-Sort-Multiple-Rows-and-Columns<\/a>Download File<\/a><\/div>\n\n\n\n

We have already shown how useful the sorting options in Excel can be. However, as with pretty much every little thing in this program, anything can be done in the way in which we want, and there is always something else to be learned.<\/p>\n\n\n\n

In the example below, we will show how to sort multiple rows and columns, that being just the ones that we want.<\/p>\n\n\n\n

Sort Multiple Rows and Columns<\/h2>\n\n\n\n

For our example, we will use the list of Marvel movies with the data of their release year, revenue rating, U.S. release year, and box office gross revenue:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We need to point out that the data above is not constructed as a table. If we did construct it in such a way, we would not be able to use the sorting options which we will show in the following text.<\/p>\n\n\n\n

Now, for example, if we want to sort only the first two columns in our data, we would select them and then go to Data >> Sort & Filter >> Sort:<\/strong><\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we click on this icon above, we will be presented with a pop-up window in which we can choose the sorting between our two columns: Release year<\/strong> and Revenue rating<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We will choose Revenue rating<\/strong> and choose to sort on Cell Values<\/strong> (other options are: cell color, font color, and conditional formatting icon), and order them from Smallest to Largest<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we click OK<\/strong>, we will have these two columns changed and sorted by revenue rating, while the rest of our data (columns C:E)<\/strong> will remain absolutely the same:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

To change the rows rather than columns, we will use the same logic. We will select range<\/strong> A12:E15<\/strong> and repeat our steps: Data >> Sort & Filter >> Sort<\/strong>. We will have the following options for sorting:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

You will notice that Excel is using our first row (in our case row<\/strong> number 12<\/strong>) as the reference point and the data beneath that row (rows 13., 14., and 15.<\/strong>) will be affected. Since the data in row number 12<\/strong> is our reference point, we can choose to sort by the data in that row, as seen in the picture above.<\/p>\n\n\n\n

We will choose to sort our rows by the last option (movie revenue) and sort it from Largest to Smallest<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we click OK<\/strong>, you will notice that our rows 13., 14., and 15.<\/strong> are affected and that the Iron Man<\/strong> movie now moved up:<\/p>\n\n\n\n

\"A<\/figure>\n","protected":false},"excerpt":{"rendered":"

We have already shown how useful the sorting options in Excel can be. However, as with pretty much every little thing in this…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nSort Multiple Rows and Columns in Excel<\/title>\n<meta name=\"description\" content=\"rong>. Download the file for step-by-step instructions on how to sort multiple rows and columns in Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sort Multiple Rows and Columns in Excel\" \/>\n<meta property=\"og:description\" content=\"rong>. Download the file for step-by-step instructions on how to sort multiple rows and columns in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-29T16:40:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T10:44:49+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Sort Multiple Rows and Columns in Excel\",\"datePublished\":\"2021-11-29T16:40:53+00:00\",\"dateModified\":\"2024-03-28T10:44:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\"},\"wordCount\":415,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\",\"name\":\"Sort Multiple Rows and Columns in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png\",\"datePublished\":\"2021-11-29T16:40:53+00:00\",\"dateModified\":\"2024-03-28T10:44:49+00:00\",\"description\":\"rong>. Download the file for step-by-step instructions on how to sort multiple rows and columns in Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sort Multiple Rows and Columns in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sort Multiple Rows and Columns in Excel","description":"rong>. Download the file for step-by-step instructions on how to sort multiple rows and columns in Excel.","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:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/","og_locale":"en_US","og_type":"article","og_title":"Sort Multiple Rows and Columns in Excel","og_description":"rong>. Download the file for step-by-step instructions on how to sort multiple rows and columns in Excel.","og_url":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/","article_published_time":"2021-11-29T16:40:53+00:00","article_modified_time":"2024-03-28T10:44:49+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Sort Multiple Rows and Columns in Excel","datePublished":"2021-11-29T16:40:53+00:00","dateModified":"2024-03-28T10:44:49+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/"},"wordCount":415,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/","url":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/","name":"Sort Multiple Rows and Columns in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png","datePublished":"2021-11-29T16:40:53+00:00","dateModified":"2024-03-28T10:44:49+00:00","description":"rong>. Download the file for step-by-step instructions on how to sort multiple rows and columns in Excel.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/11\/graphical-user-interface-application-table-desc-4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/sort-multiple-rows-and-columns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Sort Multiple Rows and Columns in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8525"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=8525"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8525\/revisions"}],"predecessor-version":[{"id":17360,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8525\/revisions\/17360"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=8525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=8525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=8525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}