Excel: Create a Drop-Down List

A drop-down list keeps data clean: people pick from a list instead of typing.

1. Select the cells

Select where the drop-down should go.

2. Data Validation

Data > Data Validation > Allow: List.

Data > Data Validation > Allow: List

3. Source

Type the choices separated by commas, or point to a range.

Yes,No,Maybe     or     =$F$2:$F$10

4. Grow automatically

Put the choices in an Excel Table (Ctrl + T) and point the source at its column so new items appear.

Ctrl + T

FAQ

How do I remove a drop-down?

Data Validation > Clear All.

Can I show a message when someone picks?

Yes, on the Input Message and Error Alert tabs of Data Validation.