Drop down arrow location for validated data

[static69]

I have created a large database of rating bullets for students at
military academy. They are all fairly long and wordy. I want to mov
the arrow from the right side to the left side so it can be see
without having to scroll right to the end of the cell. Is thi
possible with a list of validated data? Is there any other way that
can do this without the validated lists

 

[Debra Dalgleish]

You can't change the position of the dropdown arrow in a cell with data
validation. You could make the column narrower, and use code to
temporarily widen it when the cell is selected:

http://www.contextures.com/xlDataVal08.html#Wider