How do I use custom sorting in Excel? At work, sometimes we need to quickly sort the data in Excel by selecting the area to sort by, clicking sort (Ascending or descending) in the menu bar, and if sometimes this does not meet your needs, you need to customize the sort, as follows:
Open an Excel worksheet, such as the illustration:
Select the area you want to sort.
Opens the Custom Sort dialog box.
The operation process is as shown.
Description: 1, if there are multiple conditions, click the top left foot "add conditions." 2, through the option to set the direction and method of sorting.
Click OK to draw the following results.
The above is in Excel custom sort the Use Technique method Introduction, the operation is very simple, everybody has learned? Hope to be helpful to everybody!