How to Edit the Drop-Down List Source in Microsoft Excel
·2 min read
In this article
Here's how to edit the drop-down list source in MS Excel
- Locate and click on the cell that contains the dropdown list you want to modify.
- Go to the ribbon menu at the top of Excel and click on the 'Data' tab.
- Choose 'Data Validation' from the Data Tools group in the ribbon.
- Click inside the 'Source' field to modify the existing cell range or reference.
- Update the source by either selecting a new cell range or typing the reference manually.
- Click 'OK' to save your changes and update the dropdown list source.
Ready to get started with
interactive demos?
Frequently Asked Questions
No, to add new items to a dropdown list, you must either expand the source range to include new cells or modify the source data itself. The dropdown will only display items that are included in the specified source range or list.
MS Excel
