Create an in-cell dropdown 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. In the top right, tap More 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 Down Arrow. To remove the arrow, next to "Show dropdown list in cell," turn off the switch On.
  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 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.

Was this helpful?
How can we improve it?