Thanks all..

It was a major clarification for me... Really appreciate the info

JP

"Ron Coderre" wrote in message
...
Excel builds the list internally based on entries above the active cell. I
think it lists the same values that AutoComplete uses.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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