No.

Autocomplete or "Pick from list" gets its information from cells above and
below the point in the same column that you are entering new data.

A custom list entered in ToolsOptionsCustom Lists is used for autofilling
and when sorting.


Gord Dibben Excel MVP


On Thu, 17 Mar 2005 13:27:01 -0800, "poaq"
wrote: