How to Create a Drop-Down List With Multiple Options in Excel

Next Video:
How to Make a C++ Program Work on Other Computers....5

Microsoft Excel is one of the most powerful productivity tools on the planet. Create a drop-down list with multiple options in Excel with help from a software engineer with broad and extensive experience in this free video clip.

Part of the Video Series: Computers & Tech Tips
Promoted By Zergnet


Video Transcript

Hi, my name is Mathew Pierce. I'm a software engineer, and today I'm going to show you how to create drop-down lists with multiple options in Excel. Now you want to bring up Excel, and I'm going to show you two ways of doing this. One way, I'm going to show you how to make a drop-down list options that are on the same page, and the other one I'm going to show you how to make a drop-down list with options from a list that's on another page. Over here. So I'm just going to use an example. We're going to use single, double and triple scoops of strawberry, vanilla or chocolate ice cream. Just a simple little example. So to do it on the same page, what you want to do is this is my list right here. Single, double, triple. There's my size. I want to be able to have a pull-down list right there. So what you do is you just select the cell that you want the pull-down list on, then you go over to data validation, and you select the data validation tab. And then here you make sure the settings tab is selected, then you make sure you pull it from a list. And then what you can do is I have right here, you can go over here, select the range you want, hit OK and now you have a list of the pull-downs right there. Pick single, double or triple. Now for the other one, flavor, that's a list on the other side. So you select the cell, well actually you don't have to select the cell yet. You go over to the other sheet and you select those guys right there, and give it the name, Flavors. That's what I did, I gave it the name of Flavors right there. So I made this list, a name of flavors, now I can go back to the first sheet. And then what you want to do in this one, as you can see it's already pre-populated, because I've been playing with it, but you would go back to the data validation tab, click data validation, and select list and then in this box right here you can use =Flavors. That's the name that I gave it on the other sheet and that will cause that list to be selected in that pull-down. Just say OK and then you've got your chocolate, strawberry or vanilla in that list. And so that's how you do it. My name is Mathew Pierce, and today I showed you how to create a drop-down list with multiple options in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!