How do you customize the sorting of cell text or numbers in Excel?

When you select a key keyword in the Excel Sort dialog box and click Options, you can select a custom sequence as the sort order to make sorting easier and easier to control, so how do you customize the sorting method for cell text or numbers in Excel?

Method/Step

1. First, we set up a set of test data in an Excel blank cell to customize the sorting test.

2, then select our test data, click on the menu bar "sorting and Filtering"-"custom sort."

3, in the pop-up dialog box, select the "main keyword", and then in the sort by selecting the criteria for sorting.

4, here we selected the "value" and "ascending" two conditions, as shown in the figure.

5, then, we click on the icon "Options" pop-up Sort Options Menu box, select the direction and method.

6. Finally, we click OK to go back to the sorting window, and once again "OK" is done. As the figure shows, custom sorting has been done according to our requirements.

Attention matters

Sorting can be sorted by column or by row, if the order of the previous ranking is a selective paste transpose, after the sequence is completed and then transpose.

The above is in Excel how to the cell text or the number of custom sorting method Introduction, the operation is very simple, not friends can refer to this article, hope to be helpful to everyone!