Edit a Dropdown List in Excel: Sources, Steps, and Fixes

To edit a dropdown list in Excel for Microsoft 365 on Windows, select a cell that uses it, go to Data > Data Validation, and change the entries in the Source box on the Settings tab. If the source is a worksheet range or named range, edit those source cells or expand the referenced range instead; changing the validation rule alone will not change the choices stored there.

How Excel dropdown lists work

An Excel dropdown is usually a cell with Data Validation set to allow a list. The validation rule controls which entries are offered or accepted. Its source can be a short set of typed choices, a range of cells, or a named range. That distinction matters: the dropdown arrow is only the visible control, while the source determines the available options.

For example, a task tracker might offer Not started, In progress, and Done. Those choices could be typed directly into the rule, or entered in cells on a worksheet and referenced from the rule. A cell-based source is generally easier to maintain when the choices change often or when several dropdowns should use the same list.

When you select a cell with list validation, Excel normally displays an arrow at the right edge of the cell. If the arrow is missing, the cell may still have validation with the in-cell dropdown display turned off, or it may not have a list rule at all. The rule can still be inspected through Data Validation.

Edit choices typed directly into the rule

Select a cell containing the dropdown. If multiple cells share the same rule, selecting one is enough to inspect it.
Choose Data > Data Validation.
On the Settings tab, confirm that Allow is set to List.
Edit the Source box, then select OK.

A directly typed source might contain Red,Blue,Green. Replace, remove, or add items in that box. Excel uses the list separator configured for the computer, which is commonly a comma but can differ by regional settings. If the choices contain punctuation or you need a longer, easier-to-manage list, storing each choice in a worksheet cell is usually more practical than typing everything into Source.

Check the spelling, spacing, and order before accepting the change. Excel does not automatically update existing cell values when you remove an option from the source. A cell may continue to display an old value even though that value is no longer offered by the dropdown.

Change a dropdown that uses worksheet cells

If the Source box contains a cell reference, the displayed choices come from those cells. Edit the source cells to change the wording or add and remove choices within the referenced area. For example, if the list points to H2:H8, changing the text in H4 changes that option; it does not require replacing the validation rule.

Assume the choices are on the same worksheet in H2:H8. The Source box can contain =$H$2:$H$8. The dollar signs lock the reference when the rule is copied or applied elsewhere. To include a new choice entered in H9, update the source reference to cover H2:H9, or use a named range designed for the list.

To adjust the referenced range, select a cell with the dropdown, open Data > Data Validation, and inspect Source. Change the ending row or column as needed, then select OK. If several cells use the same rule, Excel may ask whether to apply the change to other cells with the same settings. Review that prompt carefully: apply it to the group only if those cells should share the revised list.

For a source on another worksheet, a named range is a dependable approach. Assume the choices are on a sheet named Lists in A2:A6. In Formulas > Define Name, create a name such as StatusOptions that refers to =Lists!$A$2:$A$6. Then set the validation Source to =StatusOptions. If the sheet name contains spaces, Excel may include apostrophes around it in the reference. Using a name avoids placing a direct cross-sheet reference in the validation Source box.

Add, remove, or reorder choices

How you change the list depends on its source:

Typed list: Edit the comma- or locale-separated items in the Source box. Reorder them there if the menu should present choices in a different sequence.
Cell range: Edit the source cells. To add an item, make sure the validation reference includes the row or column where you put it.
Named range: Edit the cells covered by the name, then adjust the name’s reference if the list has grown beyond its current range. Use Formulas > Name Manager to inspect or change a defined name.

To remove an option, delete or replace its source entry, or exclude that cell from the referenced range. Blank cells inside a referenced range can produce a blank choice in the dropdown, so remove unnecessary blank rows or tighten the range if that is not wanted. To reorder options, rearrange the source cells; Excel displays range-based choices in the order they appear in the range, not automatically in alphabetical order.

Changing the source does not clean up values already entered in dropdown cells. If you remove the choice Archived, for instance, cells that already contain Archived keep that text. Review affected records and replace old entries if consistency matters for reporting, filtering, or later analysis.

Apply a revised rule to more cells

A workbook may have many dropdown cells, and they may not all share the same validation settings. To find cells with validation, use Home > Find & Select > Go To Special > Data Validation. Choose All to select cells with any validation, or Same to find cells with the same validation type and settings as the active cell. The selection can help you identify where a shared rule is used before editing it.

You can also select the intended destination cells first, then open Data Validation and define the list rule for that selection. Take care not to overwrite unrelated validation rules in a broad selection. If a worksheet contains several kinds of dropdowns, apply the revised rule only to cells that are meant to use the same choices.

Copying a cell can also copy its validation rule, which may unintentionally replace a destination cell’s dropdown. When moving content between cells, choose a paste option suited to the task and inspect the destination rule afterward. Pasting values rather than the full cell can help avoid copying formatting and validation, but verify the result rather than assuming every paste method behaves the same way.

Set the dropdown and error behavior

The Settings tab includes options beyond the list source. Leave In-cell dropdown selected if users should see the arrow while the cell is active. If it is cleared, the rule can still restrict entries, but the list is not presented through the usual in-cell arrow.

The Ignore blank option affects how blank entries are treated by the validation rule. On the Error Alert tab, you can choose whether Excel displays an alert when someone enters a value that is not in the list. A Stop alert blocks the invalid entry through ordinary typing; Warning and Information alerts allow the user to proceed after a prompt. Add a clear input message or error message when a workbook will be used by people who may not know what the choices mean.

Data Validation is useful for guiding entry, but it is not a complete security or data-integrity system. Users can sometimes introduce values through copying, pasting, or other operations that do not behave like normal typing into a validated cell. For important records, check the data after entry and consider additional controls appropriate to the workbook.

Common problems and practical fixes

The new choice does not appear: Check that the source cells were edited and that the referenced range includes them. If you use a name, inspect its definition in Name Manager.
The arrow is not visible: Select the cell and reopen Data Validation. Confirm that Allow is List and that In-cell dropdown is selected. Also check that the active cell is not being obscured by another interface element.
The dropdown shows a blank item: Look for empty cells inside the source range and shorten the range or fill the blank with a valid choice.
An old choice remains in a cell: Removing an item from the source does not erase existing entries. Find and correct those values separately.
The Source box appears unavailable or the rule will not change: Check whether the worksheet or workbook is protected, and whether you have permission to edit it. Unprotect it only if you are authorized and know the required password.
Different cells show different menus: They may have different validation rules or point to different source ranges. Use Go To Special to locate validation cells, then inspect representative cells before applying one rule across a group.

One common misconception is that sorting a worksheet automatically sorts a dropdown’s options. A range-based dropdown follows the order of its source cells. Sort the source list itself if you want a different order, and make sure the sort does not separate the choices from related data in neighboring columns.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, select the validated cell and use Data > Data Validation to inspect or edit the rule. The dialog layout and some controls can differ from Windows, but the central task is the same: confirm the list type, change the source, and save the rule. Avoid relying on Windows-specific ribbon key sequences when following Mac instructions.

Excel for the web also provides data validation controls, though the available controls and dialog presentation can vary as Microsoft updates the service. If you cannot find a needed setting or a workbook’s rule is difficult to manage in the browser, open the file in the desktop version of Excel. Keep in mind that a workbook saved online can be opened and edited in either environment, so check the resulting dropdown after making a change.

Frequently Asked Questions

How do I edit a dropdown list in Excel?
Select a cell with the dropdown, choose Data > Data Validation, and edit Source on the Settings tab. If Source points to cells or a named range, update that source rather than typing over it in the rule.

How do I add an item to an Excel dropdown?
Add the item to the typed Source list, or enter it in the source range and extend the validation reference if necessary. If the dropdown uses a named range, make sure the name includes the new cell.

Can I edit a dropdown list that is on another sheet?
Yes. A common method is to create a defined name for the cells on the other sheet, then use that name as the validation source. You can create or inspect names through Formulas > Define Name or Formulas > Name Manager.

Why does my Excel dropdown still show an old value?
Changing the list source removes an option from future selections but does not automatically replace values already entered in cells. Find those cells and update them if the old value is no longer valid.

Why can someone type a value that is not in the dropdown?
The Error Alert may be set to Warning or Information rather than Stop, or the value may have been introduced by a paste or another operation. Check the validation settings and review entries when accuracy is important.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.