如下:
工具/原料:华为BOOK14、win7、excel2019。
1、在电脑上打开excel表格,找到需要设置下拉选项的数据。这里演示需要设置下拉选项的是“等级”这一列。
![](https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d163c3714f4e1deb48f8d5464b7?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/b8389b504fc2d5623cf85e78f51190ef77c66cb7?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/e61190ef76c6a7ef71d626b3effaaf51f2de66b7?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/8435e5dde71190efcb0b1c4adc1b9d16fcfa60b7?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/d4628535e5dde7112c22cd63b5efce1b9c1661b7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)