Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Sort Data by Multiple Columns in Microsoft Excel

Date:2019-9-16 Author:Cordelia

An Excel spreadsheet is often composed of multiple columns with various data, and they are all related in some way. You probably need to take more than one columns into consideration while sorting. So how to do it?

The Sort feature in Excel allows you to add multiple levels as the criteria to sort the data. With it, you can sort multiple columns of data simultaneously.

For instance, the exam result of a student may include the grades of multiple subjects. If you want to know his or her ranking among all the students, sure you can sort the total points. But for those student with same scores, you might need to sort them by another criterion.

How to Sort Data by Multiple Columns in Microsoft Excel

1. First, select all the cells you want to sort, then go to Data tab and click Sort.

How to Sort Data by Multiple Columns in Microsoft Excel

2. Change the settings to Sort by Total and Sort On Cell Values in the Order from Largest to Smallest.

How to Sort Data by Multiple Columns in Microsoft Excel

3. In addition to total points, if you want to take a certain subject as the secondary criteria, you can click Add Level to achieve it. For example, here I set it as Then by Subject A, Sort On Cell Values, and in the Order of Largest to Smallest. After all these changes, click OK to implement them.

How to Sort Data by Multiple Columns in Microsoft Excel

4. Now the order you set is applied to selected cells in the spreadsheet. Please note that the data will be sorted by the first level primarily. Only if there are same values, they will be sorted by the second level then.

How to Sort Data by Multiple Columns in Microsoft Excel

How to Sort Data by Multiple Columns in Microsoft Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *