Drop Down Problems

[lightbulb]

I've created a drop down list and when I click the arrow to see my choices,
the text in the drop down box is really tiny! There are only 2 options in
the drop down box, so I don't know why it is doing this. Once I select an
option, the font in the cell is avg. size. Any ideas?

Thanks!

 

[Gord Dibben]

Assuming you are speaking about a Data Validation dropdown, the default font
is 8 point and cannot be changed.

Workarounds at Debra Dalgleish's site

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


Gord Dibben MS Excel MVP