在excel中设置下拉选项操作步骤如下:
操作环境:联想笔记本XiaoXin Pro16、微软Windows 11家庭版、Excel2021等。
1、首先,在电脑中打开需要设置下拉选择项的Excel文件,并输入选择项的内容。
![](https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d16968fbef6e1deb48f8d5464d8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、鼠标选中需要设置下拉选项的单元格,点击“数据”菜单,选择“数据验证”。
![](https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb3cc515300cb33c895d0430cd8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、随后弹出“数据验证”对话框,在“验证条件”下选择“序列”,勾选“忽略空值”和“提供下拉箭头”。
![](https://iknow-pic.cdn.bcebos.com/42a98226cffc1e1754f7a8a65890f603728de9d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在“来源”输入框中框选已经设置好的下拉选项,点击“确定”。
![](https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c6874b02c95d6277f9f2ff8d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、此时在B3单元格下就会出现下拉箭头,所有的选项就会出现在下拉列表中,选择合适的选项就可以了。
![](https://iknow-pic.cdn.bcebos.com/9f2f070828381f301e51a93ebb014c086f06f0d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)