Set the custom sort for the WPS table

When using WPS to process data, it is unavoidable to encounter the use of sorting, and sometimes the sort is not simply by date or number to sort, often according to the actual situation to sort work, which makes some of the sorting function is not particularly known to people is a pain, I'm here to teach you how to use custom sorting in WPs sort Oh, first of all, let's take a chestnut, for example, with a simple table.

For example, we want to order the level of education, then we first want to prepare a custom sort sequence, separated by commas, to note that the comma here is the English input method under the comma Oh, do not use Chinese to input the punctuation, oh, copy this sequence down

And then what we're going to do is click the WPS Table button on the top left of WPS and select the option button

In the options, we select Custom sequence labels,

On the right side of the custom sequence, paste the sequence of the previous copy in the box of the input sequence, click on the confirmation after clicking Add, and then select the sort in the data

Then in the sort of the bomb box to do as the figure of the selection,

Then click the option button

Choose your own defined sequence, follow the ranks, and then click OK to complete.