Try Debra's page at:
http://www.contextures.com/xlDataVal08.html

Scroll down a little for the topics:
Data Validation Font Size and List Length
Make the Dropdown List Appear Larger, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Neil Pearce" wrote:
I have used data validation to restrict user inputs for a cell using: Data
validation, the list option and selecting "in-cell dropdown" menu.

However the worksheet has been zoomed to 60% and the list in the dropdown is
now unreadable.

Is there a way to increase the font of the dropdown list?