How to Make a Dropdown List in Google Sheets

How to Make a Dropdown List in Google Sheets

When multiple people enter data into the same spreadsheet in Google Sheets, it’s easy to make a mistake. One way to reduce the likelihood of this happening is to use drop-down lists. It’s easy to create a drop-down list in Google Sheets, so we suggest you use them as often as possible.

Watch our video tutorial where we show you how to create a dropdown list in Google Sheets, using Windows 10 and Google Chrome.

Video Transcript:

  1. How to Make a Dropdown List in Google Sheets
  2. Select one or more fields where the dropdown list will be located
  3. Click on Data
  4. Click on Data validation
  5. Open the dropdown list next to Criteria, then click on List of items
  6. Enter what will be in the dropdown list. Separate the items with a comma.
  7. Turn on the option: Show dropdown list in cell
  8. Click on Save


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *