Options in drop down box revert to small font

Gigabyte / P35-ds3l
September 13, 2010 at 23:46:21
Specs: Microsoft Windows XP Professional, 2.4 GHz / 3582 MB

I'm using a work spreadsheet, I didn't do the spreadsheet myself but coming up with ways to improve it. There is a small inconvenience where, information is selected from a drop down box created, however all the options in the drop down box when opened are showing as a really small font and hard to read.

I suggested the information it is pulling it from be in a higher font but was explained this has allready been tried and is unsure why its still showing small font in the drop down box when selected.

Wondering if there are any known causes for this and how to fix if possible, I might request checking the spreadsheet myself but its locked so cannot see the formatting size where the info is getting pulled from. I figured it would be the font size of the data but if this has been tried, i'm at a loss.

Thanks heaps if can help :)

See More: Options in drop down box revert to small font

Report •

September 14, 2010 at 03:07:43
The font size of the Drop Downs are controlled by the zoom level, which is actually a Windows function. There is nothing you can do to change the Drop Down font size directly.

This link contains a link to a Combo Box workaround:


This link offers some code options that change the zoom level when the Drop Down is selected.


I have not personally tested any of these solutions.

For more info Google:

excel drop down font size

Report •
Related Solutions

Ask Question