I used a data validation->list to make a drop-down list in a cell.
Works great.
Suddenly the dropdown box became extra wide with tons of white space at
the end of every item.
What causes this and how can I stop it?
I mean the drop down box is half the size of the screen, rather than
the size of the text it contains.
I checked my source data and the text hasn't changed, no extra spaces
in it.