I know how to use Data Validation to create a drop-down list in a
cell. However, there's a contextual menu command "Pick from drop-down
list..." that shows nothing except a blank choice. If I enter
something in the cell above it, then that item -does- appear in the
drop-down list. (Enter "1" in cell A1 and you can pick "1" from the
drop-down list that appears when I right-click in cell A2 and select
"pick from drop-down list". However, if I enter, let's say, 1, 2, 3,
4, and 5 in cells A1-A5 and then right-click in cell A6 to select
"pick from drop-down list", I see only one -blank- choice.

It's obvious this contextual menu item has nothing to do with Data
Validation (as that creates its own menu arrows to the right of the
cell) and selecting the "pick from drop-down list" must refer to some
other option I'm just not grasping.

Thanks for any assistance.

Barry