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?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false