Edit data from a DropDown List in Excel

1

I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit them as requested. However, I do not know how to edit these dropdown values. Can someone help me? Below is an example of two items that should be selected and then changed by the user.

    
asked by anonymous 01.12.2017 / 12:01

1 answer

1

Go to the data menu (1), suboption data validation (2), since you already have a list in the validation criteria, the allow option should be as list (3), edit the source or contents of the cells indicated therein (4).

    
01.12.2017 / 12:22