The list should show entries from other cells in the adjacent range, in
the same column.

Another way to display a list in a cell is to use Data Validation. There
are instructions in Excel's Help, and he

http://www.contextures.com/xlDataVal01.html

Barry wrote:
I right click on cell, find "Pick from List" option, but cannot seem to use it


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html