Then click Save button, the first drop down list has been created. In the popped out Data validation dialog box, select List from a range from the drop down list beside the Criteria section, and then click button to select the cell values which you want to create the first drop down list based on, see screenshot:ģ. First, you should insert the basic drop down list, please select a cell where you want to put the first drop down list, and then click Data > Data validation, see screenshot:Ģ. The following steps may help you to insert a dependent drop down list, please do as this:ġ. How could you deal with this task in Google sheet?Ĭreate a dependent drop down list in Google sheet Inserting normal drop down list in Google sheet may be an easy job for you, but, sometimes, you may need to insert a dependent drop down list which means the second drop down list depending on the choice of the first drop down list. How to create a dependent drop down list in Google sheet?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |