Here’s how to create and modify a drop-down menu in Google Sheets.
However, Google Chrome is recommended for optimal performance.
Open a new or existing spreadsheet.
snag the cell or group of cells where you want to place a drop-down list.
TheData validationdialog box displays, containing several configurable options.
The first, labeledCell range, specifies the location where the drop-down list will reside.
TheCriteriasetting contains a drop-down menu that offers the following options.
If the value chosen in theCriteriasection creates a drop-down list, theShow drop-down list in cellcheck box also appears.
To activate this virtual helping hand, select theShow validation help textcheck box.
Next, enter or modify the text that you wish to display.
When you’re satisfied with your selections, selectSave.
pick the cells containing the drop-down list or other data validation criteria that you wish to modify or remove.
TheData validationdialog box displays, containing several configurable options.
To modify cell behavior, make the desired changes, then selectSaveto apply the changes instantly.
To remove the drop-down list or other validation criteria, selectRemove validation.
Open a new or existing spreadsheet in the app.
When the drop-down menu appears, selectData Validation.
TheData validationinterface displays and contains several configurable options.
The first, labeledCell range, specifies the exact location where the drop-down list will reside.
This option is enabled by default.
To activate this virtual helping hand, turn on theShow validation help texttoggle switch.
Next, selectEditand enter or modify the text that you wish to display.
When you’re satisfied with your selections, tapSave.
TheData validationinterface displays and contains several configurable options.
To modify cell behavior, make the desired changes, and tap theSavebutton to apply the change.
To remove the drop-down list or other validation criteria, tapRemove Rule.
