How to editing a dropdown list in Excel
This edit is use when you have an existing dropdown list available and want to change to a new list.
Initially select the cell which contains the list (example C5)
Go to Data tab > Data Tools > Data Validation
Alternatively you could use a shortcut key ALT + D + L
Select Settings group > Allow > List > Source
Amend the source name to the new one and click OK