How to set ascending order in excel

How to set excel ascending sorting: first select the value, and click the [Data-Sort] option in turn; then select the [Options] button, and in the [Sort Options] dialog box that pops up, check [ Sort by row] option; finally select the value in [Sort by], select ascending order in [Order], and confirm.

How to set ascending sorting in excel:

1. Click to select the value in the second row, and then click [ Data]-[Sort] option.

#2. As shown below, through the operation of the previous step, the system pops up the [Sort] dialog box, click the [Options] button in the dialog box.

#3. In the [Sort Options] dialog box that pops up, check the [Sort by Row] option, and then click the [OK] button.

4. In the pop-up [Sort] dialog box, select the field to be sorted in [Primary Keyword], select a value in [Sort By], and Select ascending order in [Order], and click the [OK] button after setting.

#5. Return to the worksheet, and the values ​​in the second row are sorted in ascending order.

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to set ascending order in excel. For more information, please follow other related articles on the PHP Chinese website!