How to add a dropdown list in Google Sheets
Learn how to add a dropdown list in Google Sheets using data validation, so cells only accept approved values from a list.
Quick answer
Select the cell or range where you want a dropdown, then open Data > Data validation. Click Add rule, choose 'Dropdown' or 'Dropdown from a range' as the criteria, enter your list values, and click Done. The dropdown arrow appears immediately in the selected cells for quick data entry.
Steps at a glance
- Select the cell or range for the dropdown
- Open the Data menu and click Data validation
- Click Add rule to create a new validation rule
- Choose Dropdown or Dropdown from a range
- Enter list values or select source cells
- Click Done to apply the rule
- Test the dropdown arrow in your sheet
Summary
Dropdown lists in Google Sheets use data validation rules to restrict what users can type into a cell, offering a clickable menu of preset options instead. This keeps data entry consistent, reduces typos, and makes forms or trackers easier to fill out correctly.
Step-by-step guide
Step 1
Open your spreadsheet and select the target cells
In Google Sheets, open the spreadsheet where you want a dropdown. Click and drag to highlight the cell or range of cells that should show the dropdown menu — this can be a single cell, a column, or a group of rows.
Step 2
Open the Data validation menu
Click Data in the top menu bar, then select Data validation from the dropdown menu. This opens a panel on the right side of your screen where you'll set the rule that controls what values are allowed.
Step 3
Add a new validation rule
Click Add rule in the Data validation panel. Under Criteria, choose either 'Dropdown' to type your own list values, or 'Dropdown from a range' to pull values from cells already in your sheet.
Step 4
Enter your dropdown values
If you chose 'Dropdown', type each option into its own field and click Add another item to add more choices. If you chose 'Dropdown from a range', click the grid icon and select the cells containing your list — this works well if you've already imported data using /guides/google-sheets/import-csv or /guides/google-sheets/open-csv-file.
Step 5
Customize display options
Choose whether invalid entries show a warning or are rejected outright, and decide whether to display the dropdown as a colored chip or plain text. If needed, check Allow multiple selections to let users pick more than one value per cell.
Step 6
Save the rule and test it
Click Done to apply the rule. Click into one of the selected cells and you'll see a small arrow — click it to open the dropdown menu and confirm your options appear correctly.
Step 7
Apply the dropdown to more cells if needed
Copy a cell with the dropdown already applied and paste it into other cells to extend the same rule. This is useful when setting up a large tracker where you'll later sort a table or filter data by the dropdown values.
Why this matters
You're building a project tracker, budget sheet, or team form and want everyone to enter status, category, or department values the same way. Adding a dropdown stops typos and inconsistent entries, so your data stays clean enough to sort, filter, or summarize later.
Frequently asked questions
Can I create a dropdown list from values in another sheet?
Yes. When choosing 'Dropdown from a range', you can select cells from a different sheet within the same spreadsheet by clicking the sheet tab while selecting the range.
Can I edit a dropdown list after creating it?
Yes. Select the cell with the dropdown, open Data validation, update the criteria or values, and click Done to save your changes.
Is adding a dropdown list free in Google Sheets?
Yes. Data validation and dropdown lists are available to all Google Sheets users on the free plan with no premium features required.
Create interactive demos like this one — free, no coding required.
Start for free →