💻 Software
Excel, drop down lists
Fresh5 days ago
Mar 15, 20262847 viewsConfidence Score0%
0%
Problem
When I created custom drop down lists in excel, my excel sheets don't trim down to a smaller list when I start typing in the drop down list cell. For example if my drop down list is for USA States [AL...WY] and I type the character 'N' why doesn't my down down list give me a subset of options [...N…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel, drop down lists
Low Risk
That's because that's not how data validation works in excel. You need to use an active X control. Refer to the Contextures data validation page in general and her ComboBox Data Validation and ComboBox Depend examples in particular. Update If you do…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix