• Editing a dropdown list

  • 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