Go to the Formulas ... edit a drop-down list in Excel that was entered manually 1. Under the Data tab, click on Data Validation. 2. In the settings tab of the pop-up window, under Source, add ...