1
Open your Google Sheets document
Navigate to the specific Google Sheets document where you want to create drop-down options.
How to Create Drop Down Options in Google Sheets
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"
Accounting & Finance
2
Click Data validation
Click the Data validation option in the Data menu dropdown.
3
Click the Add rule button
Click the Add rule button in the Data validation rules sidebar to create a new dropdown option.
4
Click the Apply to range input field
Click the input field under "Apply to range" in the Data validation rules sidebar to specify the cells for the dropdown.
5
Click the color dropdown arrow
Click the small arrow icon next to the color circle for Option 1 in the sidebar to open the color palette.
6
Click the Advanced options button
Click the "Advanced options" button in the Data validation rules sidebar to reveal additional settings.
7
Select the "Reject the input" option
Click the radio button next to "Reject the input" in the Data validation rules sidebar to prevent invalid data entry.
8
Click the Done button
Click the "Done" button at the bottom of the Data validation rules sidebar to save your settings.
9
Check it out! You now have a list of items in Google sheets. Select the drop down icon to test your list.
Check it out! You now have a list of items in Google sheets. Select the drop down icon to test your list.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.