.... found via HELP!


Pick From Drop-down List command

You use the Pick From Drop-down List command to quickly insert a value into
an empty cell. The command saves you having to retype an existing value that
resides in the same column. To try it, follow these steps:

In a blank column of a worksheet, enter a list of items. "Apples,"
"oranges," "peaches," and "pears" will do if you can't think of a list
off-hand.
Right-click the cell directly below the last item, and click Pick From
Drop-down List.
Select an item from the list.

HTH

"JP" wrote:

Hello:

When I do a right click on a cell, I get the popup menu that allows the
selection of "Pick From List. . ." I did a search in Help and with the
Microsoft Knowledgebase, but could find no reference to this. How does one
populate the list...where is the list from, etc.?

Thanks.

JP