How To Add a Dropdown List in Google Sheets on Mobile

Adding a drop-down list in Google Sheets on mobile can be done through the Google Sheets app. Here’s a step-by-step guide:

1. Open Google Sheets App:
   • Open the Google Sheets app on your mobile device.
2. Navigate to Your Spreadsheet:
   • Open the spreadsheet where you want to add the drop-down list.
3. Select a Cell:
   • Tap on the cell where you want the drop-down list to be.
4. Tap on the Three Dots:
   • Look for the three dots in the upper-right corner of the screen to access additional options.
5. Choose “Data validation”:
   • In the menu that appears, look for an option like “Data validation” or “Validation.” It may be located under the “Data” or “Insert” section.
6. Set up Data Validation:
   • Similar to the desktop version, set up your data validation:
     • Choose “List of items” as the criteria.
     • Enter the list of items or select a range where your items are located.
7. Save:
   • Save or apply the data validation settings.
8. Test the Drop-down List:
   • Go back to your spreadsheet, tap on the cell you selected, and you should see a drop-down arrow or a list of options.