How to sort descending order in Excel?

How to sort in descending order in Excel? The following are the specific method steps.

1. First, we open the Excel table that needs to be sorted, as shown in the figure below

2. Select the data area that needs to be sorted, as shown in the figure below

3. Click Start in the toolbar

and then select Sort

4. In the ribbon, click "Sort" and select "Descending" in the menu that opens

Then a pop-up window will appear, as shown below

#5. In the pop-up warning box, set the sorting basis and click "Sort"

The default sorting basis is "Extend selected area", click Sorting completes the descending order operation.

The above is the detailed content of How to sort descending order in Excel?. For more information, please follow other related articles on the PHP Chinese website!