Create an in-cell drop-down list

Create drop-down lists in a cell with Google Sheets.

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. At 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 drop-down 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. At 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 that you’d like to change.
3. At the top right, tap More .
4. Select Data validation.
   • To change the items listed, go to 'Criteria' and edit the items. At 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 that you've selected, the changes will be made in the list automatically.