At work, we often use WPS forms to make some forms similar to payroll and report cards. Sometimes, in order to view the data conveniently, we sort some worksheets. The sorting here can be divided into several kinds, simple sorting, complex sorting and user-defined sorting. When we operate, we can choose the appropriate sorting method according to our own needs. Here is a big simple sorting method.

① Open the worksheet to be sorted, and click the Data tab. At this time we will see two commands: ascending and descending.

② We select the whole table, and then click the small box in ascending and descending order.

③ In the pop-up "Sort" dialog box, we can select the main keywords to sort. Here we take "Total Score" as an example, then select "Descending" and finally click "OK".

At this point, the highest score is at the top and the lowest score is at the bottom. This report card is arranged in descending order of total score.

⑤ When we set the sorting of main keywords, there will still be juxtaposition. For example, there are two parallel results here, and at this time we will sort them with secondary keywords.

⑥ Open the "Sort" dialog box again, and select the category to be sorted in "Secondary Keyword". Let's take "Chinese" as an example, then select "descending" and click "OK".

At this time, the two people with the same score, the one with high Chinese score, are in front. Similarly, if you need to add a "third keyword", the method is the same.