- Picture and text skills
Setting "data validity" in the form can improve the speed and accuracy of our data input!
So how to use this tool?
￭ For example, we want to enter gender data in this column.
Hold down the Shift key, click on the cell range where you want to enter data, the first cell and the last cell, quickly select the cell range .
￭ Click "Data" - "Validity" in the menu bar, fill in the validity conditions in the settings, and select "Sequence".
Enter (male, female) in the source, note that English commas are required here, and click OK.
There is no need to enter data at this time, just drop down and select.
￭ Data validity also allows us to avoid entering incorrect data.
For example, the length of the mobile phone number is 11. We select the cell range and set the data validity condition to the text length.
The length is set equal to 11.
When we enter data, if we enter one more digit or one less digit.
Errors will be prompted, which can effectively avoid entering incorrect data.
The data validity function is very powerful and can set a variety of conditions.
You can use it flexibly to avoid data input errors~
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-she-zhi-lu-ru-tiao-jian-he-xia-la-cai-dan.html
支付宝扫一扫 
评论列表（196条）
测试