![A screen shot of a google spreadsheet.](https://b1252519.smushcdn.com/1252519/wp-content/uploads/2022/09/Add-a-Drop-down-Box-to-Limit-Choices.jpg?lossy=2&strip=1&webp=1)
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).
Comments 0