NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
SheetSteps
Google Sheets tutorials›Data validation›Create a dropdown from a range
Google Sheets · Verified tutorial

Create a dropdown from a range in Google Sheets

Create a dropdown in B2:B4 from the range D2:D4. Do not select a value and do not change the source list.

Verified by PhilisAbout 60 seconds
Quick answer

Create a dropdown in B2:B4 from the range D2:D4. Do not select a value and do not change the source list.

Step-by-step

1

Open the practice sheetUse the example data shown below so the result is easy to check.

2

Create a dropdown from a rangeCreate a dropdown in B2:B4 from the range D2:D4. Do not select a value and do not change the source list.

3

Check the resultCompare the finished sheet with the expected result and correct the target range if needed.

Shortcut or faster method

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

Expected result

B2:B4 uses D2:D4 as its dropdown source.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select B2:B4 and repeat the final action. B2:B4 uses D2:D4 as its dropdown source.

Example spreadsheet data

This is the clean fixture used for the verified run.

TaskPriorityAllowed priorities
Draft briefHigh
Review copyMedium
Publish pageLow

Video transcript

  1. Open the prepared Practice spreadsheet.
  2. Open the practice sheet. Use the example data shown below so the result is easy to check.
  3. Create a dropdown from a range. Create a dropdown in B2:B4 from the range D2:D4. Do not select a value and do not change the source list.
  4. Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
  5. B2:B4 uses D2:D4 as its dropdown source.

Related tutorials