- Image and text skills
When we use forms to work, we often need to enter a large amount of random and repeated data.
Making a drop-down menu can help us easily complete the entry of repeated data.
Let's use this table as an example. Now we need to improve the data in the "Gender" column. We can use the drop-down menu to facilitate this.
￭ First, select the area B2-B10 where you want to add a drop-down box, click "Data" on the menu bar, and select the "Insert drop-down list" option;
￭ Select "Manually add drop-down options" in the dialog box, click the green + sign in the upper right corner to create "Male" and "Female" options respectively, and click Sure.
￭ At this time, click on the set cell, and a drop-down arrow will appear on the right. Click the arrow to select the "gender" information that needs to be filled in. .
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/ru-he-zhi-zuo-xia-la-lie-biao.html
支付宝扫一扫 
评论列表（196条）
测试