Let's say you create a data validation rule/list in A1 and point it to a sizeable range of data (say B1:B100). When you click on cell A1, the drop-down window is pre-defined to be a certain size and will display only so many of the items (in my case 8 at a time) - with a scroller to the left that allows you to see the remaining choices.

Does anybody out there know of an easy way to change the settings to make the drop-down list a bit larger (to display say, 15 items at a time)?

Thanks,