http://www.contextures.com/xlDataVal01.html Make data entry easier -- select valid entries from a drop down list on the Excel worksheet. Instructor: Debra Dalgleish, Contextures Inc. Get Debra's weekly Excel tips: http://www.contextures.com/signup01 More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Data Entry Pop Up Kit: http://www.contextures.com/datavalidationmultiselectpremium.html '---------------------------------- Transcript for Drop Down List in Excel You've created an order form, and instead of having people type the name of the item they'd like to order, you're going to make a drop down list so that people can just select from that list. That way, you'll prevent typing mistakes and people ordering things that aren't available. To start, we're going to create a list of items and we've done that on the sheet called Lists. We've typed the items in column B and now i'm going to select all those cells and we're going to give that a group of cells a name. To do that we'll click in the name box and type -- this is going to be FruitList -- the name has to be all one word We'll type, and then press the Enter key, and now with those cells selected, you can see the name Now we'll go back to be order sheet which is called data entry, and we'll select the cells where we want the list To create the list we'll use data validation, so go to the data menu, and click validation On the settings tab we'll select List -- that's what we're going to allow For the source, we start with an equal sign, and then type the name of our list Or on your keyboard you can press F3, and that will bring up a list of all the names that you've created So there's FruitList. Click ok and now it's entered for us We'll click OK, aand now you can click on any of those cells and select from the drop-down list
Comments (0)