How to Add a Dropdown List in Excel (2026 Guide)
Home›Guides›Add Dropdown
ExcelHow-To⏱ 2 min read

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.

  1. Select the target cells

    Highlight the cells where you want the dropdown to appear.

  2. Open Data Validation

    Go to the Data tab. Click Data Validation in the Data Tools group.

  3. Choose List

    In the Settings tab, under Allow, select List.

  4. 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.

  5. 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.

  1. Type your list values in a range

    Enter your items in a column, e.g., cells E1:E20.

  2. Select target cells and open Data Validation

    Select where you want the dropdowns. Data → Data Validation.

  3. Choose List and reference the range

    Allow: List. Source: =$E$1:$E$20 (use dollar signs to lock the reference).

  4. Click OK

    Dropdown appears. Adding or editing values in E1:E20 automatically updates the dropdown.

Use a Named Range for cleaner references

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

  1. Put your list on Sheet2

    Enter values in a range on a different sheet, e.g., Sheet2!A1:A20.

  2. Open Data Validation on the target cells

    Standard Data → Data Validation → List setup.

  3. 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.

  1. Set up your data with Named Ranges

    Create Named Ranges for each category. Example: a range named USA containing US cities, a range named Canada containing Canadian cities. Names must match the values in your first dropdown exactly.

  2. Create the primary dropdown

    In cell A1, use standard Data Validation → List with source USA,Canada (or reference a range containing those two names).

  3. Create the dependent dropdown

    Select cell B1. Data → Data Validation → List. In Source, enter: =INDIRECT(A1). Click OK.

  4. Test it

    Pick USA in A1 — B1's dropdown shows US cities. Change A1 to Canada — B1's dropdown updates to Canadian cities.

INDIRECT gotcha

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

  1. Select the cells

    Highlight cells with the dropdown you want to remove.

  2. Open Data Validation

    Data → Data Validation.

  3. Click Clear All

    Bottom-left of the dialog. Click OK. Dropdown removed; current values remain.

Keyboard shortcut

Data Validation Shortcuts

Open Data Validation dialogAlt + A + V + V
Open dropdown in a cellAlt + ↓
Smart Forms

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.