This interactive demo was created free with Storylane in 8 minutes. Create your own demo
How to Edit the Drop-Down List Source in Microsoft Excel
It is very easy to edit the drop-down list source in Microsoft Excel. Here’s a quick guide on how to do it:
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.
