Excel Drop-down list keyboard shortcut

[mjbons]

Hi All,

Quick question; I know that with the ALT+Down Arrow you can open a drop-down list, and by hitting the first letter of the entry you're looking for you'll navigate easily to that entry.

But what if you've got loads of entries starting with the same letter; is it possible somehow to type the first two or three letters of the entry and have excel look for those?

Thanks!

 

[jbeaucaire]

No, not with a Data Validation dropdown.

If you use the Control Toolbar ComboBox to put a dropbox control on your sheet, that control has a Property called MatchEntry - 1 - fmMatchEntryComplete...that one will autocomplete as you type.

 

[mjbons]

Thanks!

 

[KutbuDeen]

I have mistakenly keyed some keys but it shows the list of already loaded values in the list the grayed out manner in that i have seen the all the details which i have already uploaded in top cells
can anyone know what is the short cut key for this