how to sort multiple columns in excel table

#How to sort multiple columns in excel table how to

➤ Under the Home ribbon, from the Conditional Formatting and Color Scales drop-downs, choose the Green-White or any other color scale as you prefer. ➤ Select the entire column for Date of Release. Assuming that we want to sort the column for Date of Release by highlighting the data. Rather, it’ll only highlight the data in a column or row based on the sorting criteria. But this method won’t change or modify the orders of your data at all. If you want to sort your data or columns by highlighting with colors or symbols you have to choose Conditional Formatting. Conditional Formatting to Sort Multiple Columns You can sort any other columns too based on your criteria with Filter options from the column headers.ģ. You’ll get the sorted columns based on the countries of origin. ➤ Now click on the Country of Origin drop-down. You’ll find the Filter buttons on your table headers. ➤ Under the Home tab, choose Filter command from the Sort & Filter drop-down in the Editing group of commands. ➤ Select all the headers of the table first.

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 table 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. To sort multiple columns in Excel at a time, using the Sort & Filter command is the best solution. Using Sort & Filter Command to Sort Multiple Columns 5 Quick Approaches to Sort Multiple Columns in Excel 1.