Put your allowed values in a range, select the input cells and choose Data → Data Validation → List.
Visual walkthrough
Before
B2 is a free-text entry. The allowed values are in H2:H4.
After
B2 has a drop-down with three statuses.
With a Stop error alert, typing an unlisted status should be blocked.
Try it here
Change the selection to see the result and matching data rows.
List source: =$H$2:$H$4| Source cell | Value |
|---|---|
| H2 | Not started |
| H3 | In progress |
| H4 | Completed |
Step-by-step instructions
- Enter Not started, In progress and Completed in H2:H4.
- Select B2, then choose Data → Data Validation. On Settings, select List under Allow.
- Set Source to =$H$2:$H$4, enable In-cell dropdown and choose OK.
- Choose each status in B2. If invalid typed entries should be blocked, enable an Error Alert with the Stop style and test an unlisted value.
Frequently asked questions
Can I apply the list to more cells?
Yes. Select the full target range before setting validation, or copy the validated cell and use Paste Special → Validation.
Reference: Microsoft Support