Home>Article> How to sort descending order in Excel?

How to sort descending order in Excel?

不言
不言 Original
2019-04-09 15:10:22 34405browse

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

How to sort descending order in Excel?

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

How to sort descending order in Excel?

3. Click Start in the toolbar

How to sort descending order in Excel?

and then select Sort

How to sort descending order in Excel?

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

How to sort descending order in Excel?

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

How to sort descending order in Excel?

#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.

How to sort descending order in Excel?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn