Drop down List Formatting

[C Vi]

I have a worksheet that I was recently asked to add Drop Down lists too. I
added the first one and while the entire document is in 26pt Times New Roman,
the font when I click the drop down is less then 8pt. Now once I select the
name in the drop down, it becomes proper size but my colleagues need to be
able to see the names on the list and right now it is far too small to be
readable. I have tried changing their font in the lists that I am using as my
source but it hasn't made a different, please help????

 

[Gord Dibben]

If the dropdowns are created from Data Validation List, you cannot change
the fontsize which is 8 point.

Workarounds.....................

http://www.contextures.on.ca/xlDataVal08.html#Font


Gord Dibben MS Excel MVP

 

[C Vi]

Can I make the list a different way so that the font is larger.

 

[Gord Dibben]

Try a combobox from the Control Toolbox.

See Debra's site for more on that.

http://www.contextures.on.ca/xlDataVal10.html


Gord