How to Create a Dropdown List in Excel (Step by Step)

Method 1 — Static list (type the options)

Select the cells where you want the dropdown

Data → Data Validation → Data Validation

Under Allow, choose List

In the Source box, type your options separated by commas

Example: North,South,East,West

Click OK

A dropdown arrow appears in the cell.

Method 2 — Dynamic list from a range

Instead of typing options, point to a range of cells. When you add items to the range, they appear in the dropdown automatically.

In the Source box, click the range selector and highlight your list of options (e.g. a column on a separate sheet). Or type the range directly: =$F$2:$F$10.

Method 3 — UNIQUE as the source (best for live data)

Combine Data Validation with UNIQUE so the dropdown always shows the current unique values from your data:

1. In a spare column, enter: =UNIQUE(A2:A100)
2. Name that spill range: select it, type "UniqueRegions" in Name Box
3. Use =UniqueRegions as the Source in Data Validation

💡 Add an input message

In the Data Validation dialog, click the Input Message tab and type a short instruction. It appears as a tooltip when the user clicks the cell — great for shared spreadsheets.

Practice what you just learned

ExcelPro has 880+ hands-on exercises across 9 tracks — type real formulas, get instant feedback.

Start practising free →

How to create a dropdown listin Excel

Method 1 — Static list (type the options)

Method 2 — Dynamic list from a range

Method 3 — UNIQUE as the source (best for live data)

Practice what you just learned

How to create a dropdown list
in Excel