Entering the Tutorial Data
The first step to creating a drop down list in Excel is to enter the data.
Note: 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 correct cells on Sheet 1 of the worksheet:
D1 - Cookie Type:
- Click on the Sheet tab for Sheet 2.
- Enter the following data into the correct cells on Sheet 2 of the worksheet:
A1 - Gingerbread A2 - Lemon A3 - Oatmeal Raisin A4 - Chocolate Chip
The drop down list will be added to cell E1 on sheet 1.