Excel 2003 Tips for using: Special class sorting

When you use Excel 2003 for performance statistics, generally are the results by class input and calculate the personal score, and then all the class results glued together, and then the total score for the keyword from high to low arrangement, and fill the Colonel ranking, and then by class order, in order to print out the class for the unit output report card. Such a look at the transcript, you can know the class in the top 50, 100 students, each student in the school ranking. But in Excel 2003 do not know one, two, three classes ... , but in the first alphabetical order of the pinyin of the first Chinese character, the order is eight classes, two classes ..., which makes people look very uncomfortable. So I figured out how to get Excel 2003 to know a class, class two, class three ...

1, enter the 1,l2 cell in the cell L1 enter 2, then drag and choose the L1 and L2 cells, the mouse pointer to the lower right corner of the L2 cell, and so on when the mouse pointer changes to fill handle (black solid line Plus), double-click the left, automatically completed the school ranking of the fill. (Figure 1)

Figure 1

2, click the Tools menu → options, in the Open Options dialog box, select the Custom List tab, in the Input Sequence list box, type one, class two, class three, class four, class five, class six, class seven, eight, nine, 10, and the middle is separated by commas in English, followed by the "add" and "OK" buttons. (Figure 2)

Figure 2

3, click the "Data" menu → sort, in the Sort dialog box, "Main keyword" select "Class" and choose the following "Ascending", click the Options button to open the Sort Options dialog box, and then in the Custom sort order list box, select Class One, Class two ..., and then click OK to exit. See is not very obedient according to one class, class two, class three ... In the order in which they were arranged. (Figure 3)

Figure 3