Home >Topic List >How to sort in excel
How to sort in excel
In Excel, there are two commonly used sorting methods: ascending order and descending order. Ascending order means sorting according to the size of the data or alphabetical order from small to large, while descending order means sorting from large to small. Whether it's a simple ascending or descending sort, or a complex custom sort or multi-level sort, Excel can meet our needs.
How to sort results in excelHow to sort results in excel: 1. Select all data; 2. Click the drop-down arrow on the right side of [Sort and Filter]; 3. Select [Custom Sort] in the drop-down list, and the [Sort] dialog box will appear; 4. [ Select [Total Score] for Main Keywords, select [Value] for [Sort By], select [Descending Order] for [Order], and click [OK].
What to do if the excel sort is all 1The solution to the problem that the excel sort is all 1: First enter the excel table file; then click "Start - Sort and Filter - Filter" to cancel the filter; then select all the initial data and click on the lower right corner to perform normal drop-down sorting .
How to sort in excelHow to sort in excel: 1. After opening excel, select the data to be sorted and click "Data"; 2. Enter the data interface and click "Sort"; 3. Enter the sort warning interface, select the sort area and click "Sort"; 4. , enter the sorting interface, add sorting conditions, main keywords, sorting basis, order, and click "OK".
Related coursesMore>
Become a PHP Architect - Homemade PHP FrameworkIntermediate18289 plays
Learn Python and play with Excel in 2 hours to achieve efficient office automationElementary10984 plays
JS development verification form tutorialAdvanced27504 plays
Ajax message board, waterfall flow video tutorialIntermediate19718 plays
Related Resource DownloadsMore>
Related TutorialsMore>
- 03-31
- 03-28
- 05-06
- 01-13
- 08-21
- 03-20