Pick From List
 

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

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