:How to make a drop-down list-Table skills免费ppt模版下载-道格办公

How to make a drop-down list

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.

图一.png

￭ 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;

图二.png

￭ 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.

图三.png

￭ 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. .

图四.png

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