View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kojaks43 kojaks43 is offline
external usenet poster
 
Posts: 6
Default increase number of items shown in drop down list?

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