I would like to make a structure similar with a data validation list in Google Sheet so the others users could contribute to it easily. For example, when I use the sheet I select one data validation structure and there is the following fruits: "banana, apple, orange", I would like to add "grape" at this list , but I would like to do this only by typing grape on the cell, but this would say the enter is invalid. How could I do something like that?


1 Answer 1


Assuming that those fruit selection drop-down lists are in column F2:F, use =F$2:F as the "List from a range" criteria, and tick the Show warning option.

When a new entry is typed in one of the drop-down list cells in column F2:F, it gets automatically included as an option in those lists.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.