① Open the worksheet we need to sort, click the "Data" tab, and then we will see the two commands "Ascending" and "Descending".
② We select the entire table, and then click the small box below "Ascending Descending Order".
③ In the pop-up "Sort" dialog box, we can select the main keywords to sort based on. Here we take "Total Score" as an example, then select "Descending Order", and finally click "OK".
④ At this time, the highest score is at the top, and the lowest score is at the bottom. This score table is arranged in descending order by total score.
⑤ After we set the primary keyword sorting, there may still be a tie situation. For example, there are two tied results here. At this time, we will use the secondary keyword sorting.
⑥ Open the "Sort" dialog box again, select the category you need to sort in "Secondary Keywords", here we take the "Chinese" score as an example, then select "Descending Order" and click "OK".
⑦ At this time, for two people with the same grades, the one with higher Chinese scores will be ranked first. Similarly, if you need to add a "third keyword", the method is the same.
The above is what the editor said aboutI hope it will be helpful to everyone on how to use the sorting function in WPS tables. For more exciting tutorials, please pay attention to Huajun Software Park.
