How to display custom text as a label in an excel cell for a particular column?

257 views Asked by At

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".

Screenshot for sample view

1

There are 1 answers

0
WeAreOne On

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.

enter image description here