Log In
Register
Home
Active Member
May 29, 2020
Offline
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
See Answer
July 16, 2010
Offline
Hi Peter,
This functionality is only available in Excel 365 or in Excel Online. You would need to save the file on OneDrive to enable sharing of the file and opening in Excel Online.
Mynda
Answers Post
VIP
Trusted Members
December 7, 2016
Offline
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)
