How to Edit the Drop-Down List Source in Microsoft Excel
- George Apostolov
How to Edit the Drop-Down List Source in Microsoft Excel: step-by-step guide
Inside your Microsoft Excel worksheet, find and select the cell containing the drop-down list you wish to edit.
After that, navigate to the top menu bar and then click 'Data'.
Select 'Data Validation' from the available options.
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.
Once done, click 'Apply' to proceed.
After completing these steps, the source of the selected drop-down list will be updated based on your input.
Quick answer: 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.
About this Microsoft tutorial
Modify drop-down list sources in Microsoft Excel quickly by updating the cell range in the Data Validation menu and applying changes. This guide shows how to edit the Drop-Down List Source in Microsoft Excel in 6 steps, starting with "Inside your Microsoft Excel worksheet, find and select the cell containing the drop-dow..." and finishing with "After completing these steps, the source of the selected drop-down list will be updated...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to edit the Drop-Down List Source in Microsoft Excel?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Edit the Legend in Microsoft Excel, How to Edit the Task Labels in Microsoft Planner and How to Enable Macros in Microsoft Excel for Mac. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
