Dropdown not showing in Google Sheets
Create a dropdown in B2:B4 with exactly these options in this order: Not started, In progress, Done. Do not select a value.
Verified by JosephineAbout 75 secondsCreate a dropdown in B2:B4 with exactly these options in this order: Not started, In progress, Done. Do not select a value.
Step-by-step
Open the practice sheetUse the example data shown below so the result is easy to check.
Dropdown not showingCreate a dropdown in B2:B4 with exactly these options in this order: Not started, In progress, Done. Do not select a value.
Check the resultCompare the finished sheet with the expected result and correct the target range if needed.
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
B2:B4 has a three-option dropdown.
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 a three-option dropdown.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Task | Status |
| Draft brief | |
| Review copy | |
| Publish page |
Video transcript
- Open the prepared Dropdown repair spreadsheet.
- Open the practice sheet. Use the example data shown below so the result is easy to check.
- Dropdown not showing. Create a dropdown in B2:B4 with exactly these options in this order: Not started, In progress, Done. Do not select a value.
- Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
- B2:B4 has a three-option dropdown.