Create an in-cell dropdown list

Create a drop-down list

1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
2. Tap the cell or cells where you want to create a drop-down list.
3. In the top right, tap More .
4. Tap Data Validation.
5. Under "Criteria," choose an option:
   • List of items: To add an item, tap +Add and enter an item. To save an item, tap Done .
   • List from a range: Enter the cells that will be included in the list.
6. The cells will have a Down arrow . To remove the arrow, next to "Show dropdown list in cell," turn off the switch .
7. If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. If you want people to only enter items from the list, choose "Reject input" under "On invalid data."
8. In the top right, tap Save. The cells will show a drop-down list.

Change or delete a drop-down list

1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
2. Select the cell or cells you’d like to change.
3. In the top right, tap More .
4. Select Data Validation.
   • To change the items listed, go to "Criteria" and edit the items. In the top right, tap Save.
   • To delete a list, go to the bottom right and tap Remove rule.

Note: If you change the contents of the range you've selected, the changes will be made in the list automatically.