How to Create a Drop Down List in Excel That Updates

A drop-down list in Excel stops messy typing by letting people choose from approved values. The fastest route is Data Validation, and the cleanest setup depends on whether your choices live in cells, a table, a named range, or a short typed list.

Start with the table method if the list will change. Use the simpler range or typed-value method when the choices are fixed.

1. Build a drop-down from an Excel table

This is the best everyday option because table-backed lists update when items are added or removed.

1.Type the list items in a single column or row.
2.Select the list range and press Ctrl+T.
3.Select the cell or cells that need the drop-down.
4.Go to Data > Data Validation.
5.On Settings, set Allow to List.
6.In Source, select the table items, excluding the header.
7.Turn on Ignore blank if blank cells should be accepted.
8.Keep In-cell dropdown selected.
9.Select OK.

Put the choices in one column or one row, then turn that source into a table before creating the drop-down.

2. Make a drop-down from normal cells

1.Type the valid entries in one column or one row.
2.Select the destination cell or cells.
3.Open Data > Data Validation.
4.On Settings, choose List under Allow.
5.In Source, select the cells containing the valid entries.
6.Confirm that In-cell dropdown is selected.
7.Select OK.

Use this when your choices already sit on a worksheet and do not need table behavior. When you edit the source cells later, the drop-down uses those updated cell values.

3. Type short choices directly

For a tiny fixed list, skip the worksheet source and type the choices into Source.

1.Select the cell or cells where the list should appear.
2.Go to Data > Data Validation.
3.On Settings, set Allow to List.
4.In Source, type the values separated by commas, such as Low,Average,High.
5.Make sure In-cell dropdown is selected.
6.Select OK.

Use this for stable labels only. If the list will change, use cells or an Excel table.

4. Reuse choices with a named range

1.Select the source range.
2.Click the Name Box, type a name, and press Enter.
3.Or use Formulas > Define Name.
4.Select the destination cell or cells.
5.Go to Data > Data Validation.
6.On Settings, set Allow to List.
7.In Source, enter the name in the format =Name.
8.Select OK.

A named range gives the source cells a readable name, then lets you use that name inside Source. You can manage existing names from Formulas > Defined Names > Name Manager.

5. Add messages and error alerts

After the list works, add guardrails in the same Data Validation window.

Open Input Message and select Show input message when cell is selected to display a note when someone clicks the cell.
Open Error Alert and select Show error alert after invalid data is entered to block or flag entries someone types outside the list. Data validation only catches directly typed values, though; Microsoft notes copied or filled data can bypass the alert. Use Data > Data Validation > Circle Invalid Data to find those cells, and disable the fill handle plus protect the worksheet if you need stronger control.
Use Ignore blank when empty cells are allowed.

Set these while creating the drop-down, or reopen Data > Data Validation later and adjust the rule.

6. Create the list in Excel for the web

1.Open the workbook in Excel for the web.
2.Type the list entries, preferably in an Excel table.
3.Select the destination cell.
4.Go to Data > Data Tools > Data Validation.
5.On Settings, set Allow to List.
6.In Source, select and drag across the list cells, or type comma-separated entries.
7.Select Ignore blank if blank cells should be allowed.
8.Keep In-cell dropdown selected.
9.Add an Input Message or Error Alert if needed.
10.Select OK.

Excel for the web uses the same data-validation idea, with the browser path shown under Data Tools. Microsoft notes that data validation works the same in the browser except IME mode is not supported.

7. Edit remove or find existing drop-downs

When a list needs cleanup, stay in Data Validation. You can change the source, remove the rule, or find every validation cell first.

1.Select the cell with the drop-down.
2.Go to Data > Data Validation.
3.Change Source or any other setting, then select OK.
4.To remove the drop-down from selected cells, select Clear All on Settings, then select OK.

To find validation cells first, press Ctrl+G, select Special, choose Data Validation, then select All or Same. To open an existing drop-down by keyboard, select the cell, press Alt+Down arrow, choose with the arrow keys, and press Enter.

8. Choose the right advanced method

Copilot in Excel can help eligible Microsoft 365 users create or apply data-validation drop-downs where the feature is available.
Office Scripts can apply list validation with inCellDropDown in supported work or school Microsoft 365 environments.
VBA can create list validation in the Excel desktop app with Validation.Add.
Excel JavaScript API add-ins can set Range.dataValidation for supported Microsoft 365 Excel hosts.
Form Control and ActiveX Combo Box controls are desktop form controls, not normal in-cell drop-down lists. ActiveX controls are also disabled by default in Microsoft 365 and Office 2024, so avoid them for new drop-down workflows unless your organization deliberately enables them in the Trust Center.
Excel for iPhone can view and select existing data-validation choices, but it does not add or update rules.

For normal worksheet cells, use Data Validation. Other Microsoft-documented tools serve narrower jobs. Do not use Excel 4.0 or XLM macro approaches for a new drop-down workflow. Microsoft documents Excel 4.0 macros as a legacy macro feature.