# Answer check: Excel Dropdown Missing a New Item? Expand Its Source Range

In a workbook copy, a dropdown in D2 first uses A2:A4, then its source expands to A2:A5. D2 offers Queued, In progress, Done, and Waiting; selecting Waiting displays that exact text. The CSV supplies source text, not a preset validation rule.

The practice data is fictional. Reconcile each row before applying the method to a real file.