# How to Edit the Drop-Down List Source in Microsoft Excel

> To edit the drop-down list source in Microsoft Excel, select the cell with the list, click 'Data' in the top menu, and open 'Data Validation'. Next, update the cell range or reference in the 'Source' input field, and click 'Apply' to save your changes.

Canonical: https://livedemo.ai/tutorials/how-to-edit-the-drop-down-list-source-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3caaab56e05a00fe4360/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, find and select the cell containing the drop-down list you wish to edit.
2. After that, navigate to the top menu bar and then click 'Data'.
3. Select 'Data Validation' from the available options.
4. Next, click the "Source' input field and make your desired changes. You can reselect the cell range you wish to use or type the cell reference manually.
5. Once done, click 'Apply' to proceed.
6. After completing these steps, the source of the selected drop-down list will be updated based on your input.