How Excel customizes the table content sort

1, we now open a worksheet in Excel, click on the "Start" tab of the Ribbon, and select the "Sort and filter" icon in the edit area. Then click on its Inverted triangle button, in the Pop-up drop-down menu, select "Custom Sort" command;

2, then the window will pop up a "Sort" dialog box, click on "column" Under the "Key" button to choose the Drop-down, in the Drop-down button under Sort by select value, select Ascending under the Order option group, and then click OK for example, here we select the "Math" column for ascending order;

3, after the set back to our worksheet, you can find in the Math column in the data from childhood to large in ascending, the following figure;

Tips:

Ascending is the sort of placing the smallest number in the data at the top of a small to large size. If the user wants to sort the data in a pompous to small order, in the Sort dialog box that just pops up, select Descending under the Drop-down button of the order option, where we arrange the size of the data, so you must also select the value command in the Drop-down button under sort by.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join