Auto-expand/rich auto-complete option in Excel combo boxes

[Keith Howard]

Does this feature exist in Excel, like it does in Access? That would make it
much easier to selection items from a lengthy look-up list?

Thanks.

Keith

 

[Gord Dibben]

Not if your selection list is a Data Validation list dropdown.

A Combobox list has autocomplete.

See here for more on this.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP