G
Gord Dibben
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 Tools>Options>Custom Lists is used for autofilling
and when sorting.
Gord Dibben Excel MVP
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 Tools>Options>Custom Lists is used for autofilling
and when sorting.
Gord Dibben Excel MVP