For example, the above is sorted by the total score, and the operation method is:

1, click the total score cell;

2. Click Start-> Sort-> Custom Sort;

3. The sorting dialog box pops up, and you can choose ascending or descending order according to your needs;

(1) If the primary keywords are the same at the secondary keywords, select the sorting basis, such as selecting mathematics;

(2) If the second-level keywords at the third keyword are the same, select the sorting basis, such as selecting the language;

According to the above settings, that is, if the total score is the same, it will be sorted by math scores, and if the math scores are the same, it will be sorted by Chinese scores.