The specific steps are as follows: 1. Open the excel table that you want to sort. Before sorting out the data, you must first know what the keywords are. Usually, the keyword is the header of the table, and the keyword represents the attribute of this column of data.
2. Start sorting a simple keyword. According to the descending order of "Total Score", click the mouse where there is data in the table, then click "Data" in the menu, and then sort.
3. Sort by the total score in descending order, so you only need to select the total score of the main keyword and then sort in descending order. 4. Sometimes the sorting requirements are very high. For example, first sort the students in a class in ascending order by class name, and then sort the students in a class in descending order by total score. At this time, you need to sort two keywords, the first keyword is "class" and the second keyword is "total score", so you need to choose as shown in the figure when sorting.
Expand data Excel chart Other operations: First, let the data display different colors. In the student score analysis table, if you want the score with a total score greater than or equal to 500 to be displayed in blue, the score with less than 500 will be displayed in red.
The operation steps are as follows: first, select the column where the total score is located, and execute format → conditional format. In the pop-up conditional formatting dialog box, set the first box as the cell value and the second box as greater than or equal to it; Then enter 500 in the third box and click Format. In the Cell Format dialog box, set the font color to blue, and then click Add to set it to less than 500 and the font to red in the same way. Finally, click [OK] button. At this point, as long as your total score is greater than or equal to 500 points, it will be displayed in blue numbers, otherwise it will be displayed in red.
Second, sort the results reasonably. If you need to sort the students' grades from high to low, then if the total score is the same, sort by surname.
The operation steps are as follows: first, select all data columns, select data → sort, then select the total score in the primary keyword drop-down list in the pop-up sorting window, select the descending radio box, select the name in the secondary keyword drop-down list, and finally click OK. Third, control data types.
When you enter a worksheet, you only need to enter integers instead of decimals in the cells, or only enter date data. Fortunately, Excel 2003 has the functions of automatic judgment, real-time analysis and pop-up warning.
Select some specific cells first, and then select Data → Validity. In the Data Validation dialog box, select the Settings tab, and then select a specific data type in the Allow box. Of course, this type also has some specific requirements, such as the integer must be between a certain number and so on. In addition, you can select the Error Warning tab and set the display mode of the warning message after the input type is wrong.
If it is not set, a warning window will open by default. Now there are hints everywhere. When you enter the wrong type of information or do not meet certain requirements, you will be warned.
References:
Baidu Encyclopedia: Excel Chart.
Excel custom sort sort
1. First, you need to tabulate the new custom rule, that is, edit the new collation in the new cell range.
2. After editing, click the file and select the "Options" button in the pop-up function list.
3. In the pop-up dialog box, click the "Advanced" button on the left to enter the function selection area, scroll the mouse scroll bar, and find and click "Edit Custom List" at the bottom of the page.
4. Select "New Series" in the pop-up dialog box, and associate it with the newly arranged cell range you just edited.
5. Click Import, and you can see that the new collation has been displayed in the dialog box.
6. Edit and customize and confirm. Click OK again to enter the table.
7. Select the table title, and then click Filter under Data so that you can select a collation from the list.
8. Click "Custom Sort" in the drop-down list to open a dialog box. In the dialog box, "Main Keyword" will select the column name where the sort is located, and the sort will be saved as a numerical value. In the order, select Custom Order.
9. In the custom order pop-up dialog box, select the new sorting rule you just edited, and click OK to finish sorting.
10. When viewing the table again, the collation becomes a user-defined rule.
How to sort the keywords in excel tables?
Excuse me, is it a form in excel?
If so, you can do this:
One: for those who want to disrupt the order of all walks of life. If all three columns of A B C have the contents of your table, start another column, assuming it is column D, enter =RAND () in cell D 1, and then move the mouse to the lower right of this cell. When the mouse turns into a black cross, pull it down until the nth row (provided that all rows from A 1 to An are tables), so that a series of columns of D will appear. Select "column d" in "main keywords", ascending (or descending, it's all the same), and then confirm, and you're ok.
Two: for you to follow a certain order of arrangement. In excel, select "Table-Sort" in the menu bar, and the same dialog box will appear as before. Just sort according to your keywords in ascending or descending order.
The above answers are original answers, hoping to solve the problems you need to solve ~
How to set a custom sequence sort in Excel?
1. Select all the cells where the data is located, click Data-Sort-Check Data with Title, select Education as the main keyword, and then select User-defined Series.
2.Excel provides many user-defined sequences on this interface by default, including English week, English date, week, Chinese month, heavenly stems and earthly branches and so on. Enter the sequence you want in the window on the right. Pay attention to separate each word by pressing enter. When the sequence is finished, click Add, and then you will see the sequence you defined in the window on the left. Now click OK.
3. At this point, you will return to the sorting settings window, select the order you just set, and then click OK. 4. This is the effect after sorting in a custom order.
.
How to set the ascending and descending sort of excel tables?
1. Open the Excel worksheet, select the column to sort, right-click, click Sort in the pop-up window, and click Ascending in the pop-up menu on the right.
2. Click to expand the selected area in the small window that pops up, and then click the sort button below.
3. As shown in the figure, you can see the scores from low to high. The name in the left column also changes position with the change of score.
4. Similarly, select a column to sort, right-click, click Sort in the pop-up window, and click Descending in the pop-up menu on the right.
5. As shown in the figure, you can see that the scores are arranged from high to low. The name in the left column also changes position with the change of score.
How to arrange from high to low in Excel?
Materials/tools: Excel20 10
1, we entered some data first, but we entered it at will, so we didn't arrange it from high to low.
2. Select all table contents with the mouse, and then click the right mouse button to set the cell format.
3. When setting the border, set the outer border of the table as a thick border, and set the inner lines of the table as thin lines.
4. After setting, click the blank position with the mouse, and you can see that the table looks much clearer now.
5. Then we reselect all the tables and click Sort and Filter-Descending in the property bar at the top. (descending order means from high to low)
6. After selecting descending order, we can see that the data in the table has been automatically arranged from high to low.
How to sort in ascending order in excel?
For example:
A, B, C, D, E ... Lake K
Serial number, name, class Chinese and mathematics total score ranking
Sorting:
1. Click the "Sort in Descending" button on the common toolbar to sort the scores from high to low.
2. Select all data regions, perform data/sorting, and then select the column title to sort (or express by column) in the main keyword column, select descending order, and then click OK.
Note: In the process of sorting, the row where the sorted data is located changes as a whole with the order of data arrangement.
Filter: If you want to compare some data, you can perform Data/Filter/Auto Filter. Each cell in the column header has a drop-down button, which you can click to select from the list.
If you just sort, you don't need to filter.
How to sort in a table
What should you do when you get a messy and miscellaneous report and the boss asks you to sort it out? It doesn't matter. I am here. I'll teach you all sorts of sorting methods.
This is a messy report. Let's make it more organized. Open this report in Excel.
The easiest way is to click the shortcut button in ascending or descending order on the toolbar. If you can't find it, you can click Data-Sort.
The effect is this. It's simple. Suddenly I feel that the world is very clean.
If you think this sorting method is far from satisfying you, it doesn't matter, there are many patterns, you can choose your favorite pattern. Click Data-Sort to sort according to the data to be sorted.
It doesn't matter, even if this doesn't satisfy you, you can still choose options and customize your data.