How to Add a Dropdown List in Excel
Dropdown lists in Excel are built with Data Validation. This guide covers static lists (Yes/No/Maybe), dynamic lists from a range, dropdowns pulling from another sheet, and dependent dropdowns where one selection filters the next.
⚡ Quick Answer
Select the cells, click Data → Data Validation, choose List in the Allow field, then either type values comma-separated in Source (e.g., Yes,No,Maybe) or reference a range ($A$1:$A$10). Click OK.
Method 1: Simple typed list
Best for short lists (2-10 items) that won't change often.
Select the target cells
Highlight the cells where you want the dropdown to appear.
Open Data Validation
Go to the Data tab. Click Data Validation in the Data Tools group.
Choose List
In the Settings tab, under Allow, select List.
Enter values separated by commas
In the Source box, type your values:
Approved,Pending,Rejected. Do not include spaces after commas unless you want them as part of the value.Click OK
Selected cells now show a dropdown arrow. Click the arrow to pick a value.
Method 2: Dropdown from a cell range
Better for longer lists or lists that change over time. Values live in a range; the dropdown pulls from it.
Type your list values in a range
Enter your items in a column, e.g., cells
E1:E20.Select target cells and open Data Validation
Select where you want the dropdowns. Data → Data Validation.
Choose List and reference the range
Allow: List. Source:
=$E$1:$E$20(use dollar signs to lock the reference).Click OK
Dropdown appears. Adding or editing values in
E1:E20automatically updates the dropdown.
Instead of $E$1:$E$20, define a Named Range: select the range, go to Formulas → Define Name, name it Statuses. Then in the Source box just type =Statuses. Easier to maintain when the list grows and clearer for anyone reading your formulas.
Method 3: Dropdown from another sheet
Put your list on Sheet2
Enter values in a range on a different sheet, e.g., Sheet2!A1:A20.
Open Data Validation on the target cells
Standard Data → Data Validation → List setup.
Reference the other sheet
In Source, type
=Sheet2!$A$1:$A$20. Or, better, use a Named Range (works across all sheets).
Method 4: Dependent dropdowns (cascading)
The classic use case: pick Country in cell A1, then cell B1 shows only cities in that country.
Set up your data with Named Ranges
Create Named Ranges for each category. Example: a range named
USAcontaining US cities, a range namedCanadacontaining Canadian cities. Names must match the values in your first dropdown exactly.Create the primary dropdown
In cell A1, use standard Data Validation → List with source
USA,Canada(or reference a range containing those two names).Create the dependent dropdown
Select cell B1. Data → Data Validation → List. In Source, enter:
=INDIRECT(A1). Click OK.Test it
Pick USA in A1 — B1's dropdown shows US cities. Change A1 to Canada — B1's dropdown updates to Canadian cities.
INDIRECT requires the Named Range names to match A1's value exactly. If A1 contains "United States" but your Named Range is "USA", it fails silently — B1's dropdown is empty. Keep names simple and single-word where possible.
Add an input message and error alert
Data Validation has two extra tabs that improve UX:
- Input Message tab — set a tooltip that appears when the user clicks the cell ("Select a status from the list").
- Error Alert tab — customize what happens if the user types something not in the list. Options: Stop (blocks invalid input), Warning (asks to confirm), Information (allows but notifies).
How to remove a dropdown
Select the cells
Highlight cells with the dropdown you want to remove.
Open Data Validation
Data → Data Validation.
Click Clear All
Bottom-left of the dialog. Click OK. Dropdown removed; current values remain.
Keyboard shortcut
Data Validation Shortcuts
Excel Wizard — auto-build data entry forms
Setting up dropdowns cell-by-cell gets tedious for large forms. Excel Wizard's AI can generate an entire input form: dropdowns for categorical fields, date pickers, number ranges, calculated summaries — all set up in one pass. Just describe the form you need.
Install Excel Wizard →Frequently asked questions
How do I create a dropdown list in Excel?
Select the cells where you want the dropdown, go to Data tab, click Data Validation. In the Allow field, choose List. In the Source box, either type your values separated by commas (Yes,No,Maybe) or reference a range of cells containing the values ($A$1:$A$10). Click OK.
How do I add a dropdown list from another sheet?
In the Data Validation Source box, reference the range on another sheet using the standard reference format: =Sheet2!$A$1:$A$10. Or better, create a Named Range for the list (Formulas → Define Name) and reference it by name in Source: =MyList. Named ranges make dropdowns easier to maintain when your list grows.
How do I make a dependent dropdown in Excel?
Create Named Ranges for each sub-list (e.g., 'Fruits' contains Apple, Banana; 'Vegetables' contains Carrot, Lettuce). In the first dropdown cell, use a normal list validation. In the second cell's Source, use =INDIRECT(A1) where A1 is the first dropdown cell. The second dropdown now shows values from whichever list matches the first cell's value.
How do I remove a dropdown list in Excel?
Select the cell with the dropdown, go to Data → Data Validation, click Clear All in the bottom-left corner, then OK. The dropdown is removed but the current value in the cell remains. To remove dropdowns from multiple cells at once, select all of them before opening Data Validation.