How to Create Dropdown in Google Sheets: Easy Step-by-Step Guide

To create a dropdown in Google Sheets, select the cell(s) where you want the dropdown, then go to Data > Data validation. Choose List of items or List from a range as the criteria, enter your options, and click Save to add the dropdown.

Syntax

Google Sheets uses Data Validation to create dropdown lists. The main parts are:

• Cell Range: Where you want the dropdown.
• Criteria: Defines the dropdown options, either as a list of items separated by commas or a range of cells.
• Show dropdown list in cell: Enables the dropdown arrow.
• On invalid data: Choose to show a warning or reject input if data is not in the list.

google_sheets

1. Select cell(s) for dropdown
2. Go to Data > Data validation
3. Under Criteria, select:
   - List of items: enter options separated by commas (e.g., Yes,No,Maybe)
   - List from a range: select a range of cells with options
4. Check 'Show dropdown list in cell'
5. Click Save

Example

This example creates a dropdown in cell A1 with options Red, Green, and Blue.

google_sheets

1. Click cell A1
2. Go to Data > Data validation
3. Under Criteria, select 'List of items'
4. Enter: Red,Green,Blue
5. Make sure 'Show dropdown list in cell' is checked
6. Click Save

Output

Cell A1 now shows a dropdown arrow. Clicking it lets you pick Red, Green, or Blue.

Common Pitfalls

Common mistakes when creating dropdowns include:

• Not selecting the correct cell range before applying data validation.
• Typing options with extra spaces, which creates unwanted spaces in dropdown choices.
• Forgetting to check 'Show dropdown list in cell', so no arrow appears.
• Using a range with empty cells, which adds blank options.

Always double-check your options and range before saving.

google_sheets

Wrong way:
- Entering options as " Red, Green , Blue " (with spaces)
Right way:
- Entering options as "Red,Green,Blue" (no extra spaces)

Quick Reference

Step	Action
1	Select cell(s) for dropdown
2	Go to Data > Data validation
3	Choose Criteria: List of items or List from a range
4	Enter options or select range
5	Check 'Show dropdown list in cell'
6	Click Save

Key Takeaways

Use Data > Data validation to create dropdown lists in Google Sheets.

Choose between 'List of items' or 'List from a range' for dropdown options.

Always check 'Show dropdown list in cell' to see the dropdown arrow.

Avoid extra spaces in options to keep dropdown choices clean.

Select the correct cell range before applying data validation.