I tried this and no "Format Control" shows in the menu. I have office 2007.

"Jollymon67" wrote:

Rght click over the drop down menu. Select "Format Control" from menu. Click
on "Control" tab. You should see a line that says "Drop down lines:" and then
a box with a number in it. Increase the value of the number in this box to a
value equal to, or greater than the number of lines you need to display.
Select OK

"kojaks43" wrote:

Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k