如下:
操作设备:戴尔电脑。
操作系统:win10。
操作软件:excel电子表格2017。
1、在电脑上打开目标excel电子表格,找到需要设置下拉选项的数据。这里演示需要设置下拉选项的是等级这一列。
![](https://iknow-pic.cdn.bcebos.com/3bf33a87e950352a6a88b1984143fbf2b3118bb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后找到一出空白列,输入所要填写的四个等级(A/B/C/D),如果有需要,可以将四个字母隐藏。
![](https://iknow-pic.cdn.bcebos.com/3b87e950352ac65cbdecf2e3e9f2b21192138ab1?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/11385343fbf2b21122c711ded88065380dd78eb1?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/e850352ac65c1038fd975a52a0119313b17e89b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击确定后返回,即可在Excel电子表格中设置下拉框选项。
![](https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b509e1674c29735e5dde6116eb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)