how to add a drop down list in google sheets

Our goal is to deliver the most accurate information and the most knowledgeable advice possible in order to help you make smarter buying decisions on tech gear and a wide array of products and services. ZDNET's editorial team writes on behalf of you, our reader. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers. Neither ZDNET nor the author are compensated for these independent reviews. This helps support our work, but does not affect what we cover or how, and it does not affect the price you pay. When you click through from our site to a retailer and buy a product or service, we may earn affiliate commissions. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. If you change the content of the range you select, the changes are made in the list automatically.ZDNET's recommendations are based on many hours of testing, research, and comparison shopping. Then, under 'Display Style,' select either:

To change the display style: Click Advanced options.

To change the options listed, edit the items under 'Criteria.'.

Select the cell or cells you want to change, then select an option:.

To remove the value from the list, change the source range or any other item’s color. Important: If you delete a value with an assigned color from the criteria source range when the dropdown is populated from a range, the value and color will still appear under criteria, but as uneditable.

Click Advanced options, and under 'If the data is invalid:,' select 'Show a warning.'.

If you want people to be able to enter items not from the list:

OPTIONAL: If you enter data in a cell that doesn’t match an item on the list, it is rejected.

Click Add another item to add additional dropdown values.Dropdown from a range: Choose the cells to include in the list.On the Data validation rules panel, under 'Criteria,' select an option:.

Enter In the Menu, under the components section, click “ Dropdowns.'.

Select the cell or cells where you want to create a dropdown list.Create drop-down lists in a cell with Google Sheets.

How to add a drop down list in google sheets