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

Contact Us for a Free Consultation and Quote

You can call us now on 020 3817 6945 or fill out the form below.

The contact form requires that you configure reCAPTCHA in the site configuration.

The contact form requires that you select an email template.