How to sort by the specified target in EXCEL?

1. First, we open the excel software in the computer and open the excel table, and find that the provinces are irregular at present.

2. Then, we click Options under File Options.

3. Then, we click the Edit Custom List option under Advanced Options.

Then we arrange them according to the provinces we want, such as Hebei, Hubei, Heilongjiang, Anhui and Hunan.

5. Click Sort to customize the sort.

6. Then we enter sorting options in the list box.

7. Finally, fine-tune the table, and the table will be sorted according to the set order.