Tag: Data 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 …

Autocomplete Workaround for Validation Dropdowns Read More »

Tagged with: , , , , ,

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 …

Dependent Dropdown using INDEX Read More »

Tagged with: ,