How to Create Drop Down Options in Google Sheets
- Lindsey Bly |
- 11 steps |
- 16 seconds
This guide will show you how to create a drop down option in Google Sheets so you can select from a list of items. Google Sheets calls this "Data Validation"
1
Go to your Google sheet
2
Click "Data"
3
Adding the drop down to Google Sheets requires adding a Data Validation. Select "Data Validation".
4
Click in the "Cell Range" field to select the cells you'd like to add your drop down to.
5
Highlight the cells and click OK.
6
Google gives a few options on how to select your list for your drop down - click "Criteria" and select your preferred method. We'll show you how to select from a list of items.
7
Enter the items in the list separated by a comma.
8
If you want to require that someone selects an item from your list, select "Reject input". If you'd like the list to be more of a suggestion and allow them to still add their own items, select "Show warning"
9
Click "Save"
10
Check it out! You now have a list of items in Google sheets. Select the drop down icon to test your list.
11
Great work 🎉!
