How To Google Sheet Drop Down List. Note that the name needs to be exactly the same as its parent category. Now we will click Data then Data validation.
It gives users a clear look at all the available options and also makes sure the user selects only the items allowed. Select the cells where you want to delete checkboxes and drop-downs all of them at once or select particular cells while pressing Ctrl. In this case it would be Fruits.
How to add a drop-down menu in google sheet.
Using Data Validation to Insert a Drop-Down List Into a Google Sheets Cell Once youve opened the sheet youre working on inserting a drop-down list is easy. In this case it would be Fruits. Open a spreadsheet in Google Sheets. Select the cells that have the fruits A2A5.