How to create a drop down list in Excel

Here's to how you can create a drop-down list in a cell or group of cells:

1. Create a list, every entry per cell on a column.
2. Select the cell to where to put the drop-down list
3. @ Data ribbon, goto Data Validation
    @ Settings Tab, @ Allow field, select List
    @ Source, select the created list in step#1
    OK

To end: count then share blessings like Web traffic exchange to others