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 FrameworkIntermediate17385 plays
Learn Python and play with Excel in 2 hours to achieve efficient office automationElementary10450 plays
thinkphp3.2 basic video tutorialElementary158173 plays
SVN video tutorial (Chuanzhi Podcast)Elementary39111 plays
Related Resource DownloadsMore>
Related TutorialsMore>
- 03-31
- 03-28
- 05-06
- 01-13
- 08-21
- 03-20