如何在Excel中创建一个下拉列表? [英] How to create a drop-down list in Excel?
问题描述
我在Excel中有一列值,如下所示:
I have a column of values in Excel, like this :
如何将其转换为下拉列表,例如列中的每一行将具有该下拉列表
How do I turn this into a drop-down list, such at each row in the column will have that drop-down list (with dog, cat , fish, bat , toad. .. all inside )
谢谢!
推荐答案
第一步是在下拉列表中列出您想要看到的项目,但是您的spreadhseet中的任何地方,如下所示:
First step is to make a list of the items you want to see in the drop-down, but anywhere in your spreadhseet , like so:
然后下一步是点击功能区中的数据验证按钮:
Then the next step is to click the "Data Validation" button in the ribbon :
确定,第3步是在数据有效菜单中单击设置,然后从 drop-drown:
Ok, step 3 is to click "Setitngs" in the "Data Valid" menu , and choose "List" from drop-drown:
第4步是点击列表子菜单中的那个小蓝色图标:
Step 4 is to click on that little blue icon in the "List" sub-menu :
下一步是简单地突出显示您需要的单元格。
The next step is to simply highlight the Cells you needs.
已完成现在。这里是下拉列表:
Finished now. Here is dropdown :
这篇关于如何在Excel中创建一个下拉列表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!