- Image and text skills
The shortcut key Ctrl+E can help intelligently identify the rules by comparing the relationship between strings, and then quickly filling.
◾Take this table as an example. If you want to fill in the numbers 1, 2, 3, etc. It is a numerical value with 1.1 as the rule.
First enter 1.1 in the auxiliary column, then click the "Home" tab - "Fill" "Button - "Smart Fill" button.
This will fill it. In addition, smart filling can also be used extensively Used in scenarios such as character extraction and character replacement.
1. Extract characters
If we want to extract everyone's birthday, we first enter the correct birthday in the first person's birthday column.
Then click the "Home" tab - "Fill" button - "Smart Fill" button.
Its shortcut key is "Ctrl+E".
2. Replace characters
Using smart filling, we can replace certain characters in the original string in batches.
Take mobile phone number encryption as an example. We first enter the correct mobile phone number in the first mobile phone number encryption column.
Then click the "Home" tab - "Fill" button - "Smart Fill" button.
Its shortcut key is "Ctrl+E".
3. Add characters
Using smart fill, we can add additional characters in batches based on the original characters.
Take adding a book title number as an example, click the "Home" tab - "Fill" button - "Smart Fill" button That’s it.
Its shortcut key is "Ctrl+E".
4. Merge characters
Smart filling can help us meaningfully merge data scattered in different columns into one column.
Click the "Home" tab - "Fill" button - "Smart Fill" button.
Its shortcut key is "Ctrl+E".
5. Reorganizing characters
Smart filling can help us reorder the original characters.
Click the "Home" tab - "Fill" button - "Smart Fill" button.
The shortcut key is "Ctrl+E", have you learned it?
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-zhi-neng-tian-chong-Ctrl-E-shi-yong-tian-chong-kuai-jie-jian.html
支付宝扫一扫 
评论列表（196条）
测试