Home  >  Article  >  Topics  >  How to sort by grades in excel

How to sort by grades in excel

尚
Original
2019-06-13 16:43:165282browse

How to sort by grades in excel

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:

How to sort by grades in excel

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:

How to sort by grades in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn