:Beginner's tutorial on tables. Sort numbers by size. Sort text by first letter.-Table skills免费ppt模版下载-道格办公

Beginner's tutorial on tables. Sort numbers by size. Sort text by first letter.

  • Image and text skills

In work, we usually encounter situations such as sorting data, so how to sort numbers or initials of letters from small to large?

Take the final transcript of the following class as an example. If you want to sort quickly, how should you do it?

 

分界线.png


First, select the data to be sorted, click "Start" - "Sort" drop-down selection "Descending order", can be selected in the sorting edit box< span style="font-size: 16px;"> Expand the selected areaor"With the currently selected area","Sort by currently selected area"means to sort only the data in the current column, Select Extension Selected area".

 

排序1.gif


If you need to follow the student list, the first letter of the last name How to sort this table from A to Z?

Click the "OK" button, or you can select "Custom Sort" and select the data to be sorted.Click the "Sort" drop-down and select "Custom Sort". In the pop-up custom sort edit box,Select the main keywordColumn C is sorted according to the selected numerical order, select ascending order, or click the "Options" button, You can choose two sections: direction and method. After selecting, click the "OK" button.


排序2.gif







Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-xin-shou-jiao-cheng-shu-zi-an-da-xiao-pai-xu-wen-zi-an-shou-zi-mu-pai-xu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion