I created a drop down list using Validation. However I noticed that when
right-clicking on a cell there's a choice for "pick from drop down list".
When I do that on my cell containing the drop down list it's empty.
Apparently this right-click list is filled a different way, other than
validation. Can someone help?