Office Dễ Hiểu

How to create a drop-down list in Excel

Use Data Validation to choose a status from a fixed list.

Put your allowed values in a range, select the input cells and choose Data → Data Validation → List.

Visual walkthrough

DataData ValidationSettingsList

Before

B2 is a free-text entry. The allowed values are in H2:H4.

After

B2 has a drop-down with three statuses.

Check the result

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 cellValue
H2Not started
H3In progress
H4Completed
ResultB2 = Not started

Step-by-step instructions

  1. Enter Not started, In progress and Completed in H2:H4.
  2. Select B2, then choose Data → Data Validation. On Settings, select List under Allow.
  3. Set Source to =$H$2:$H$4, enable In-cell dropdown and choose OK.
  4. 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