<\/figure>\n\n\n\nWe 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 <\/figure>\n\n\n\nWhen 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 <\/figure>\n\n\n\nWe 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 <\/figure>\n\n\n\nWhen 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 <\/figure>\n\n\n\nTo 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 <\/figure>\n\n\n\nYou 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\nWe 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 <\/figure>\n\n\n\nWhen 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 <\/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":"\n
Sort Multiple Rows and Columns in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n