Add a Drop-down Box to Limit Choices (6/20)


If the entry in a certain column has a limited number of choices, you can easily limit the possible choices and save time by creating a drop-down in Google sheets. First, select the cells where you want to create the drop-down box. Next, click on Data → Data Validation. Then you will have to fill in the information.

In the 'Criteria' section, you can choose an option that suits you. If you choose 'List from a range,' you have to choose the cells that list the choices to be included in the drop-down box. You can also choose 'List of items' and enter the choices, separated by commas (no spaces).

talkKs editorial
Use the comment section to suggest new list items for inclusion

Comments 0

Your email address will not be published. Required fields are marked *

Solve : Which Number is Larger 2 or 0 ?

You are invited to the talkKs Reader Community

Join Now