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

Google Sheets tutorials›Data validation›Edit data validation

Google Sheets · Verified tutorial

Edit data validation in Google Sheets

Edit the dropdown validation in B2:B4 so it has exactly these options in this order: Not started, In progress, Done. Clear the existing cell values after changing the rule.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Edit the dropdown validation in B2:B4 so it has exactly these options in this order: Not started, In progress, Done. Clear the existing cell values after changing the rule.

Step-by-step

1

Select the targetEdit the dropdown validation in B2:B4 so it has exactly these options in this order: Not started, In progress, Done.

2

Apply the changeClear the existing cell values after changing the rule.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

B2:B4 has the requested three-option dropdown and no selected values.

Common mistake

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

Troubleshooting

Re-select B2:B4 and repeat the final action. B2:B4 has the requested three-option dropdown and no selected values.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Status
Draft brief	Open
Review copy	Closed
Publish page	Open

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Edit the dropdown validation in B2:B4 so it has exactly these options in this order: Not started, In progress, Done.
Apply the change. Clear the existing cell values after changing the rule.
B2:B4 has the requested three-option dropdown and no selected values.