excel 2002 question for pick from list with autocomplete function

[Morris]

enter data in a cell from a list you specify with auto complete function

 

[Gord Dibben]

"Pick from list" only provides a list of unique contiguous items in a column.

Autocomplete also works only with contiguous data in a column.


Gord Dibben MS Excel MVP