You’ve created an order form and instead of having people type the name of the name of the item that they’d to order, you’re going to make a drop down list so people can just select from that list. In that way, you’ll prevent typing mistakes and people ordering things that aren’t available.
To start, we are going to create a list of items and we’ve done that on the sheet called lists. So we’ve typed the items in column B and now I’m going to select all those sells and we are going to give that a group of cells and name. To do that we’ll click in the name box and type, this is going to be fruit list, the name has to be all one word. So we’ll type and press the enter key and now with those cells selected, you can see the name. now we go back to the order sheet which is called data entry and we’ll select the cells where we want to list.
To create that 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 are going to allow. And for the source, we start with an equal sign and then type the name of our list or on your key board you can press F3 and that will bring up a list of all the names that you’ve created. So there’s fruit list, click ok and now it’s entered for us. We’ll click OK and now you can click on any of those cells and select from the drop down list.
Transcription by:
Scribe4you Transcription Services