Font Size in drop down boxes

[manster]

I have a drop down box in one column that I can't seem to change the Font
Size of. How do I go about it.

 

[Peo Sjoblom]

Not possible if you are using data>validation, Debra Dalgleish has a
workaround


http://www.contextures.com/xlDataVal08.html#Font

 

[JLatham]

You don't have that capability with data-validation drop downs. One
work-around is to set up a drop-down control that moves around on the sheet
to where you need it and you can control things such as the font size in it.

You can see how this is done, over at this page:
http://www.contextures.com/xlDataVal10.html

 

[JLatham]

Second attempt ... sys error, so don't know if this will be a repeat or not.

Can't adjust font size in data-validation drop downs. But you can use a
drop-down from the controls toolbox (View | Toolbars | Control Toolbox) and
the detailed instructions from this page:
http://www.contextures.com/xlDataVal10.html