When you have made the selection and then you change the parent drop down, the dependent drop down list would not change and would, therefore, be a wrong entry.įor example, if you select the ‘Fruits’ as the category and then select Apple as the item, and then go back and change the category to ‘Vegetables’, the dependent drop down would continue to show Apple as the item. Reset/Clear Contents of Dependent Drop Down List Automatically Using the SUBSTITUTE function within the INDIRECT function makes sure that spaces are converted into underscores. For example, when you create a named range with ‘Seasonal Fruits’, it will be named Season_Fruits in the backend. So when you create a named range using more than one word, Excel automatically inserts an underscore in between words.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |