How to Make a Drop

1. Type the entries you want in the drop-down box. Place one word in each cell in a single column. For example, you may want a drop-down box in cell A1 limited to red, yellow and blue. Type 'Red' in cell 'B1,' 'Yellow' in cell 'B2' and 'Blue' in cell 'B3.'
2. Click on 'Data > Validation > Settings' in Excel 2003 or 'Data > Data Validation > Data Validation' in Excel 2007.
3. Click on 'List' in the Allow box.
4. Enter the location of the inputs for the list box. In the above example, the inputs are in cells B1 to B3, so enter '=B1:B3.' Click on the 'In-cell drop-down' box if it isn't already checked.
5. Click on 'OK.'