In a data validation dropdown list, you can't change the font size.
There are a couple of programming workarounds he
http://www.contextures.com/xlDataVal08.html#Font
billybob wrote:
I have a drop down menu created within workbook (not on the toolbar) and when
I click the cell to view the list in the pull down the font is very small. I
can not see a way to adjust this font size. please help
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html