I have a Google Sheets document which is shared with nearly thirty people and I added data validation dropdown to all the cells to not entering different values except I defined.

This data validation dropdown has nine items and I want to the fifth, sixth, seventh, eighth and nineth items can be selectable by only owner of the document. Can you please explain how I can do this?


1 Answer 1


Google Sheets doesn't include a built-in feature to limit who can select certain option from a data validation drop-down but you might extend Google Sheets by using Google Apps Script more specifically by using an on edit trigger, it might be a simple or an installable trigger.

To use Google Apps Script you should know the basics about JavaScript.


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.