Hi, 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 :)
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:
http://www.contextures.com/xldatava...
This link offers some code options that change the zoom level when the Drop Down is selected.
http://www.contextures.com/xldatava...
I have not personally tested any of these solutions.
For more info Google:
excel drop down font size