Editing a dropdown list

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