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

Quick summary

To edit a drop-down list source in Microsoft Excel, select the cell with the drop-down, open Data Validation from the Data menu, and update the Source field with a new cell range or reference. This process lets you quickly change the available options in any existing Excel drop-down list without rebuilding it from scratch.

Steps

1. In your Microsoft Excel worksheet, find and select the cell containing the drop-down list you wish to edit.
2. Navigate to the top menu bar and click 'Data'.
3. Select 'Data Validation' from the available options.
4. Click the 'Source' input field and make your desired changes — reselect the cell range or type the cell reference manually.
5. Click 'Apply' to confirm your changes.
6. The drop-down list source will be updated based on your input.