G Guest Dec 23, 2004 #1 I right click on cell, find "Pick from List" option, but cannot seem to use it
D Debra Dalgleish Dec 23, 2004 #2 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 here: http://www.contextures.com/xlDataVal01.html
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 here: http://www.contextures.com/xlDataVal01.html
