Entering the Tutorial Data
The first step to creating a drop down list in Excel is to enter the data.
The drop down list will be added to cell C1.
Note: The data for the drop down list has been situated next to the drop down list in order to simplify this tutorial.
Normally the list data would be placed in a column outside the data area of the worksheet.
In addition, the tutorial instructions do not include formatting steps for the worksheet.
This will not interfere with completing the tutorial. Your worksheet will look different than the example on page 1, but the drop down list will give you the same results.
Enter the following data into the cells indicated:
A2 - Gingerbread A3 - Lemon A4 - Oatmeal Raisin A5 - Chocolate Chip B1 - Cookie Type: