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!