Specific steps for sorting:
Select all the data in the table, click "Data", click "Sort", in the pop-up dialog box Select the sorting conditions and click OK to sort the results. You can also find the sorting option from the start menu bar
Example: Rank all students in the table according to their total scores
1. Select all data in the table:
2. Click "Data", click "Sort", select the sorting conditions in the pop-up dialog box, and click OK to sort the results, as shown in the following figure:
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to sort by grades in excel. For more information, please follow other related articles on the PHP Chinese website!