How to Work with dropdown lists in Microsoft Office Excel
This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can press f3 for the list names as well. Click okay to perform this. Now you can click on the cell and choose from the list. This video shows you a great example for using drop down lists.