How to Modify a Drop-Down List in Excel

To modify a drop-down list in Excel, select a cell that has the list, then go to Data > Data Validation. On the Settings tab, change the items in the Source box, check Apply these changes to all other cells with the same settings, and select OK.

How you edit it depends on where the list’s items come from, so first check the Source box.

Applies to: Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016 on Windows. Checked against Microsoft Support on September 24, 2026.

Step 1: Find where the list comes from

Select a cell with the drop-down, then select Data > Data Validation. The Source box shows one of these:

• Typed items, such as Small,Medium,Large. Edit them right there.
• A cell range, such as =$F$2:$F$5 or =Lists!$A$2:$A$5. Edit the cells, and the range if it needs to grow.
• A name, such as =Sizes. Edit the cells, then the name in Name Manager.
• A table column, usually through a name or INDIRECT. Edit the table, and the list updates by itself.

Edit a typed list

1. Select a cell that has the drop-down list.
2. Select the Data tab, then Data Validation in the Data Tools group.
3. In Source, add, remove, or reword items, with a comma between each one, for example Small,Medium,Large,X-Large.
4. Check Apply these changes to all other cells with the same settings.
5. Select OK.

Edit a list that comes from cells

1. Change, add, or delete the items in the source cells. The drop-down changes right away.
2. If you added items below the old range, open Data > Data Validation and extend the Source range, for example from $F$2:$F$5 to $F$2:$F$6.
3. Check Apply these changes to all other cells with the same settings, and select OK.

Tip: insert new items inside the range (for example, above the last item) and Excel extends the range for you.

Edit a list that uses a name

1. Update the items in the source cells.
2. Select Formulas > Name Manager.
3. Select the name, such as Sizes, and change Refers to so it includes every item. Select the check mark to save it.

4. Select Close. Every drop-down that uses the name updates.

Make the list grow automatically

The easiest long-term fix is an Excel table:

1. Select your list of items and choose Insert > Table.
2. Give the item column a name in Formulas > Name Manager (for example, Sizes referring to the table column), and use =Sizes as the drop-down’s Source.

New rows you add to the table then appear in the drop-down automatically. Microsoft recommends tables for this reason. If the list sits on a sheet that other people fill in, see how to make a fillable form in Excel to lock everything except the input cells.

Existing entries don’t change

Editing the list doesn’t change values people already picked. If you renamed or removed an item, old cells may now hold values that aren’t in the list. To find them, select Data > the arrow next to Data Validation > Circle Invalid Data.

Change the message or the error alert

The same Data Validation box controls what people see when they use the list. Select a cell with the drop-down and open Data > Data Validation:

• Input Message tab: type a short tip, such as “Pick a department,” that appears when someone selects the cell.
• Error Alert tab: choose what happens when someone types a value that isn’t in the list. Stop blocks it, Warning asks them to confirm, and Information just lets them know.
• To allow any entry while still offering the list, clear Show error alert after invalid data is entered.

If you changed several cells, check Apply these changes to all other cells with the same settings before you select OK.

Keep the list sorted and free of duplicates

In Excel for Microsoft 365, a formula can build a clean list for you. If your raw entries are in A2:A50, type this in an empty column, for example D2:

=SORT(UNIQUE(FILTER(A2:A50,A2:A50<>"")))

The formula lists each entry once, in alphabetical order, and skips blank cells. Then set the drop-down’s Source to =$D$2#. The # tells Excel to use the whole result, so the drop-down updates whenever the raw list changes.

Edit a drop-down on a Mac or in Excel for the web

The steps are almost the same. In Excel for Mac and Excel for the web, select the cell, then select Data > Data Validation (on the web, it may be under Data > Data Tools). Change the Source box and save. Lists that point to a named range or table also work, and edits sync for everyone who opens the shared file.

Find, copy, or remove a drop-down list

• Find every cell with a list: select Home > Find & Select > Data Validation.
• Copy a list to other cells: copy a cell with the list, select the new cells, then Home > Paste > Paste Special > Validation. See how to copy a drop-down list in Excel.
• Remove a list: select the cells, open Data > Data Validation, select Clear All, then OK. The values already in the cells stay.

If Data Validation is grayed out

• You’re still editing a cell. Press Enter or Esc first.
• The sheet is protected. Select Review > Unprotect Sheet.
• The workbook is shared or read-only, or several sheets are grouped. Ungroup sheets by right-clicking a sheet tab and selecting Ungroup Sheets.

Frequently asked questions

Can I sort the items in a drop-down list?

Yes, if they come from cells. Sort the source cells, and the drop-down follows the new order. A typed list shows items in the order you typed them.

How long can a typed list be?

The Source box holds up to 255 characters. For longer lists, put the items in cells instead.

Why doesn’t the drop-down arrow appear?

Open Data Validation and make sure In-cell dropdown is checked. If it is, the arrows may be hidden with other objects: go to File > Options > Advanced, find For objects, show under Display options for this workbook, and select All.

Can a drop-down allow more than one choice?

Not on its own. A Data Validation list holds one value per cell. To pick several items, use one column per item with checkboxes instead. In Excel for Microsoft 365, select the cells and choose Insert > Checkbox. Each checkbox stores TRUE or FALSE, which formulas can count.

How do I count how often each option is picked?

Use COUNTIF. If the choices are in B2:B100 and you want to count “Sales”, type =COUNTIF(B2:B100,”Sales”). To count every option at once, point COUNTIF at your list of options, such as =COUNTIF($B$2:$B$100,D2), and fill it down next to each one.

Can I make a list that depends on another list?

Yes. See how to create a dependent drop-down list in Excel.

To add color to choices, see how to create a drop-down list in Excel with colors. Microsoft’s guide is Add or remove items from a drop-down list. More help is on our Excel Help & Guides page.

Related: How to create a multi-select drop-down in Excel.

Related: How to share an Excel file as a link.

Related: How to insert a hyperlink in an Excel cell with other text.

Related: how to create a Yes/No drop-down in Excel.

Related: how to use data validation in Excel.