New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Dropdown rejects valid value

Google Sheets · Verified tutorial

Dropdown rejects valid value in Google Sheets

Apply data validation to A2:A4 with exactly these allowed dropdown values in this order: High, Medium, Low. Keep the existing values.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

Apply data validation to A2:A4 with exactly these allowed dropdown values in this order: High, Medium, Low. Keep the existing values.

Step-by-step

1

Select the targetApply data validation to A2:A4 with exactly these allowed dropdown values in this order: High, Medium, Low.

2

Apply the changeKeep the existing values.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A2:A4 retains its values and accepts the three requested dropdown options.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A2:A4 and repeat the final action. A2:A4 retains its values and accepts the three requested dropdown options.

Example spreadsheet data

This is the clean fixture used for the verified run.

Priority

High

Medium

Low

Video transcript

Open the prepared Dropdown repair spreadsheet.
Select the target. Apply data validation to A2:A4 with exactly these allowed dropdown values in this order: High, Medium, Low.
Apply the change. Keep the existing values.
A2:A4 retains its values and accepts the three requested dropdown options.