The good news is that you can use a combo box (very similar to a data
validation drop down list) and set the number of items displayed.

The bad news is that I don't have Excel 2007 and have no idea where combo
boxes are to be found. In prevous versions they were 2 mouse clicks away.

--
Biff
Microsoft Excel MVP


"kojaks43" wrote in message
...
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