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-ru-men-zhi-nan-xun-su-fen-lie-yu-gao-xiao-zheng-li-shu-ju-ji-qiao.html
"Getting Started with Tables: Tips for Quickly Sorting and Organizing Data Efficiently"
In the "Contact Information" worksheet, the entered data has not yet been classified. To classify it into: list, mobile phone number, gender, you can follow the steps below: 1. First use the shortcut key `CTRL+A` to select all table contents in the worksheet. 2. Click the "Column" function in the "Data" menu, select "Column by delimiter", and then click "Next". 3. In the delimiter selection, if the half-width comma (comma in English characters) is used in the data, use the default option. If you are using a full-width comma (Chinese comma), you need to check "Others" and enter the Chinese comma. 4. After confirming that it is correct, click "Finish" and the data will be sorted according to the selected delimiter. At this time, insert a row in the first row of the table and enter the column titles: "List", "Mobile Number", and "Gender" to organize the table data. The following are image resources used to illustrate the operation steps: - Image and text alignment diagram: [Image and text alignment diagram.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e1ea7da86ff61befb1c583b6784f105d.png) - Recording GIF example: [Recording_2019_08_20_15_17_25_824.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/43e0c7f7ce64d54c1ece8be33d1c245b.gif) - Another recording GIF example: [Recording_2019_08_2 0_15_20_36_228.gif ](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/f8259186e9b661922ac99465aace7c88.gif) Please note that since you requested that only the content itself be returned, I did not include the HTML tags and video information. The above steps and image resources can help you organize and classify your data.
Like (810)
Reward
支付宝扫一扫
评论列表(196条)
测试