Tag: dynamic formulas

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: , , , , ,

Validation Dropdown lists based on Table Columns ranges

Up until quite recent versions of Excel (I am guessing a little here because I only have Office 365 so always have the latest and forget when I discovered this) if you wanted a dynamic list for your Validation Dropdowns,

Tagged with: , , ,
Top