准备工具/材料:装有windows 10的电脑一台,Microsoft Office 家庭和学生版 2016 excel软件。
查找EXCEL中下拉列表的来源的办法如下:
1、首先,您可以单击excel表格中的“品种”下拉菜单,您可以看到此时显示了四个品种名称。
![](https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93dc6b7c17e913df8dcd00054f6?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/c995d143ad4bd11394f27abb54afa40f4bfb0578?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/d31b0ef41bd5ad6e0f04a7638fcb39dbb7fd3cbe?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/a2cc7cd98d1001e94a6adb86b60e7bec55e797e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、原始“品种类别”可以更改为以前修改的新品种数据。
![](https://iknow-pic.cdn.bcebos.com/503d269759ee3d6d79a648424d166d224e4aded3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)