
Active Member

May 29, 2020

Hi
I have created a spreadsheet which the user will complete. To help with data entry I have created a drop down list. However, my drop down list is quite long - over 100 possible entries. So the user will need to scroll down quite a long list to get to the required entry.
Many of the entries are in a similar format - see table below.
I wondered if there was a 'predictive text' feature within Excel. So for example, if the user enter 1 only the entries beginning with 1 would be shown. If they continued (say) with 1D then only those entries will be displayed until they got to the required entry. Also, it they entered a incorrect value (say) 1T then an error would be displayed.
Am I asking for too much?
BTW - I am using an quite old version of Excel - 2013!
1C | 2C | 3C | ||
1D | 2D | 3D | ||
1H | 2H | 3H | ||
1S | 2S | 3S | ||
1NT | 2NT | 3NT | ||
1Cx | 2Cx | 3Cx | ||
1Dx | 2Dx | 3Dx | ||
1Hx | 2Hx | 3Hx | ||
1Sx | 2Sx | 3Sx | ||
1NTx | 2NTx | 3NTx | ||
1Cxx | 2Cxx | 3Cxx | ||
1Dxx | 2Dxx | 3Dxx | ||
1Hxx | 2Hxx | 3Hxx | ||
1Sxx | 2Sxx | 3Sxx | ||
1NTxx | 2NTxx | 3NTxx |
Many thanks,
Peter

VIP

Trusted Members

December 7, 2016

Hello,
If there is only one drop down list then you can try using a PivotTable and its filter field, as described in the blog post searchable drop down list in Excel.
Br,
Anders
1 Guest(s)
