How to sort wps according to score

Sort method: First open the excel table, select the cells that need to be sorted; then click the "Start" - "Sort" option at the top of the page, and select "Descending" in the drop-down menu; then in the new pop-up Select "Extend selected area" in the "Give sorting basis" window; finally click the "Sort" button.

The operating environment of this tutorial: windows7 system, WPS Office 2019 version, Dell G3 computer.

Run the WPS software, create a new XLSX table file, and enter the student's name and grades in the table.

#Select the results column, and then click the [Sort] option under the [Start] menu. The sort drop-down menu appears with [Ascending Order], [Descending Order], and [Custom Sort] options.

Click [Descending Order] under the [Sort] option. [Sort Warning] will appear on the page. Click "Expand Selected Area" under "Give Sorting Basis". Then click the [Sort] button.

The student scores are arranged in descending order from high to low.

Related learning recommendations: excel tutorial

The above is the detailed content of How to sort wps according to score. For more information, please follow other related articles on the PHP Chinese website!