Drop down List Formatting
 

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????

Drop down List Formatting
 

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


On Tue, 24 Feb 2009 06:25:02 -0800, C Vi
wrote:

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????

Drop down List Formatting
 

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

"Gord Dibben" wrote:

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


On Tue, 24 Feb 2009 06:25:02 -0800, C Vi
wrote:

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????