I want to create a custom template for users with data validations. I have completed the data validation part but I want to display all the cell values in a certain columns as dropdown values with a label like "Select from dropdown".

I want to create a custom template for users with data validations. I have completed the data validation part but I want to display all the cell values in a certain columns as dropdown values with a label like "Select from dropdown".

Copyright © 2021 Jogjafile Inc.
Once you applied the List, you can add the Text "Select from dropdown" by copy and paste (as value) to the list cells. Then you have it as you want, but once you choose a value from the drop down and delete it again, then the cell will remain empty. The text "Select from dropdown" will not display anymore. Solving this, you will need to use VBA programming.