Tag: Data Validation dropdowns

Autocomplete Workaround for Validation Dropdowns

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown

Tagged with: , , , , ,

Dependent Dropdown using INDEX

Data Validation Dependent Dropdowns are important practical feature to make your spreadsheets more usable and robust.   Data Validation Dependent Dropdowns are dropdowns which change according to a another dropdown choice.  For example if I have a data set with say

Tagged with: ,