Select the cell (or cells) containing the drop-down list
Go to the Data tab
Click Data Validation
In the Settings tab, under Allow, confirm it is set to List
Edit the list in one of these ways:
Type new values in the Source box (comma-separated)
Select a different range by clicking the Select Range icon and choosing the new cells
If using a named range, update the named range to point to the new data
Click OK
