increase number of items shown in drop down list?

Giganews Newsgroups
Subject: increase number of items shown in drop down list?
Posted by:  kojaks43
Date: Sat, 11 Aug 2007

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

Replies