But in this case, you cannot add criteria for two or more columns simultaneously. Assigning Filter Options on the Table Headersīy using Filter buttons on the table headers, you can sort the columns more easily. In Column G, the prices are sorted based on the orders of the country names as we’ve assigned the order for prices as the secondary criteria for sorting.Ģ. Like in the picture below, you’ll have your sorted data for all columns at once. ➤ Change its order by Smallest to Largest. ➤ Now select Price from the next drop-down. ➤ Click on Add Level to assign another criterion. ➤ Change the order by Z to A from the Order drop-down. ➤ Tap on the Sort by drop-down & select Country of Origin. ➤ Under the Home ribbon, select Custom Sort command from the Sort & Filter drop-down in the Editing group of commands. After that, the device prices will be sorted by smallest to largest. We’re going to sort the names of the countries of origin by the order of Z to A. We want to add 2 criteria for sorting columns in our dataset.
#HOW TO SORT MULTIPLE COLUMNS IN EXCEL 2013 HOW TO#
Read more: How to Sort Data in Excel Using Formula In our dataset below, there are 6 columns containing some random names of computer brands, device types, model names, countries of origin, dates of release and prices of the devices. It’ll let you add & choose different options to sort any range of data.
![how to sort multiple columns in excel 2013 how to sort multiple columns in excel 2013](https://i.ytimg.com/vi/2Xsp91IIr1E/maxresdefault.jpg)
To sort multiple columns in Excel at a time, using the Sort & Filter command is the best solution.
![how to sort multiple columns in excel 2013 how to sort multiple columns in excel 2013](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2016/12/excel-2013-combine-three-columns-into-one-4.jpg)
Using Sort & Filter Command to Sort Multiple Columns 5 Quick Approaches to Sort Multiple Columns in Excel 1.