Add a Drop-Down List in Google Sheets
Create a clean, reusable list of allowed values, preserve valid data already in the cells, and prevent spelling variants—or ask SheetsX to apply the rule across an exact range.
Reviewed by the SheetsX team
How to add a drop-down list in Google Sheets
Select the target cells, then choose Insert → Dropdown. Add each allowed value under Criteria, choose Chip, Arrow, or Plain text as the display style, and decide whether invalid input should be rejected or only show a warning. Click Done, then open one cell to test every option. For a maintained list, choose Dropdown from a range instead of typing options directly.
Watch SheetsX create a Google Sheets drop-down list
The Agent adds one strict four-option rule to C2:C7, keeps every valid status, fills only the blank C7 cell, and leaves the rest of the sheet unchanged.
“On Sheet1 add a dropdown list to cells C2 through C7 with these options: Not started, In progress, Blocked, and Done. Keep every other cell unchanged, preserve the existing valid status values, and set the blank cell C7 to Not started. Do not add a new sheet.”
Create a dropdown and protect the data
Check existing values before applying a strict validation rule. Capitalization and whitespace differences can make a value invalid even when it looks similar.
Google's official dropdown instructions- 1
Audit the current values
List the distinct values already in the target cells and decide how blanks should be handled.
- 2
Select the exact range
Highlight only the cells that should share the same validation rule.
- 3
Add the options
Choose Insert → Dropdown, then type the options or select a source range.
- 4
Set invalid-data behavior
Reject invalid input for a controlled field, or show a warning for a flexible field.
- 5
Save and verify
Click Done, open a dropdown, and confirm the list order and existing values.
Typed options, a source range, or SheetsX?
| Method | Option source | Best use |
|---|---|---|
| Dropdown | Options typed directly into the validation rule | Short, stable lists such as status, priority, or approval state. |
| Dropdown from a range | Values read from cells elsewhere in the workbook | Long or frequently updated lists such as owners, SKUs, or regions. |
| SheetsX Agent | A plain-English request that applies the data-validation rule | Adding or updating dropdowns across an exact range with safeguards. |
Use a source range for changing lists
Keep approved values on a small reference tab, use Dropdown from a range, and update the source cells when the list changes.
Reject or warn?
Reject invalid input for workflow fields. Show a warning when exceptions are legitimate and should remain editable.
Describe the validation rule in one prompt
Name the sheet and range, list every allowed value in order, say whether the rule is strict, and specify what should happen to existing and blank cells.
Install SheetsX- Open a new Agent chat for a clean task context.
- Name the sheet and exact target range.
- List the allowed options in the intended order.
- State whether existing valid values must be preserved.
- Define how blanks should be filled and protect every other cell.
Google Sheets drop-down list questions
How do I add a drop-down list in Google Sheets?+
Select the target cells, choose Insert → Dropdown or Data → Data validation → Add rule, enter the options under Criteria, choose the display style and invalid-data behavior, then click Done.
Can a Google Sheets drop-down use values from another range?+
Yes. In the data validation panel choose Dropdown from a range, then select the source cells. Changes to that source range update the available choices automatically.
How do I stop people entering values outside the list?+
Open Advanced options in the validation rule and use the reject-invalid-input behavior. Use Show a warning only when values outside the list should still be allowed.
Will adding a dropdown erase existing cell values?+
It should not erase valid existing values. Check that every current value exactly matches one of the options before applying a strict rule. The SheetsX demo preserves five valid statuses and fills only one blank cell.
How do I edit or remove a drop-down list?+
Select a dropdown cell and choose Data → Data validation, or click the dropdown and its edit icon. Change the criteria or display style, or choose Remove rule to delete the validation rule.
Can SheetsX create a Google Sheets drop-down list?+
Yes. Tell the SheetsX Agent the sheet, exact range, ordered options, how to handle existing and blank values, and which cells must remain unchanged. The recorded example applies one strict dropdown rule to C2:C7.