Follow these steps to create a drop-down selector in Excel. We will assume you are working in a new workbook.

1. Add text to cells A1, A2, A3 and A4
   • A1 - boy
   • A2 - girl
   • A3 - mom
   • A4 - data
2. Select cell B1
3. In the top menu of excel, select Data
4. Select Data Validation > Data Validation
5. In the Data Validation dialog box, on the Settings tab, select List in the Allow drop-down selector
6. Select the icon to the right of the sources field, and highlight cells A1 through A4 (you could also type =$A$1:$A$4 into the sources field)
7. Select OK

Cell B1 should now contain a drop-down selector with the options in cells A1 through A4.