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

Rate:

(No Ratings Yet)

Loading...