课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Show me how to make a drop-down list

Show me how to make a drop-down list - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

Show me how to make a drop-down list

“

- [Instructor] A friend has asked us, hey, how do you make those cool dropdown lists? And I'm going to ask you to show our friend 'cause you know that there are two different types. There are dynamic and static. In cells C3 through C7, make static dropdown lists that only accept Y or N. In D3 through D7, make dynamic lists, meaning you can add and remove entries, and the dropdown list will adjust without you having to remake it. And use your own data for our friend's example, be creative. Go ahead, create the dropdown list, come back, and you can watch me go through it. All right, you're back. Okay, I'm going to highlight this range. I'm in the Data tab. Go to Data Validation, List, and then capital Y, comma, capital N. Okay, check it out. Let's put an N there, and let's test this. Let's put a seven. (computer chiming) Great, that's exactly what we wanted. We should only be able to choose Y or N. Now the…

内容